Access 97 Performance Leak after Switching to W2K3 Fileserver "berni" <spaems[ at ]gmail.com> 04.03.2006 21:56:33 Hi all, we use several Access97 Applications in a Multiuser Environment - after we migrated the Fileserver which was serving the Access-Databases from Novell to Windows 2003, the Users complained about bad Access Performance. That brings me to my Question: Is there a way to Tune a Windows 2003 Fileserver for Access Performance? Thanks for your Tips in Advance berni[ at ]berlin

Re: Access 97 Performance Leak after Switching to W2K3 Fileserver Tony Toews <ttoews[ at ]telusplanet.net> 04.03.2006 23:35:40 "berni" <spaems[ at ]gmail.com> wrote: [Quoted Text] >we use several Access97 Applications in a Multiuser Environment - after >we migrated the Fileserver which was serving the Access-Databases from >Novell to Windows 2003, the Users complained about bad Access >Performance. > >That brings me to my Question: Is there a way to Tune a Windows 2003 >Fileserver for Access Performance? There are some server specific things to review at the Access Performance FAQ page at http://www.granite.ab.ca/access/performancefaq.htm One of them is if you have too many folders in the path of the back end MDB. That is \\share_name\app_name\MDB_Backend.MDB is fine but \\sharename\folder1\folder2\folder3\folder4\folder5\folder6\MDB_Backend.MDB is not as good. Another might be virus scanning on the server. Ensure that MDBs are not scanned for viruses. Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm