vb access 97 suddenly very slow over network
Posted on 2004-09-27
I have a little application written in VB6 with an access 97 backend. The application is run from a drive shared on a windows 2000 server. There are about 10 desktops all running xp. Both the server and the desktops have the latest sp's.
A couple of days ago the application started to run very slowly. I have made no changes to it for months. I can browse files on the server from a desktop without any problems, accessing word and excel files stored on the server seems to work fine. When I run the application from a local drive it runs fine.
Opening the access database itself seems to be very slow too. The database is not too big, only about 80mb. I'm not really a network person have run out of ideas. Any help would be greatly appreciated. The people who use this application are starting to become a little twitchy and when pushed too far they are capable of extreme violence.