MS Access performance problem
I have NT 4.0 with service pack 5 installed. I am using MS Office 97 with service release 2. I am hooked up to a Novell fileserver with Novell 5. My network connection is 10 BaseT running at 10 megabits. I have a large Access database on the fileserver (about 75 MB). There are about 50 machines with the above configuration. On some of the machines the database opens immediately. On others it takes 10 minutes to open. Can anyone give me some ideas where to look to find out why some are so slow? Any help is appreciated.