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.
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.