Access Database Performs Slows on Windows 2003 Server
Posted on 2005-03-03
I have a client website that is unfortunately, powered by MS Access. The nature of the db is a customer list where selects and updates are done very often. There are about 3-5 users logged in and performing these tasks at a time. This is on a windows 2003 server.
The performance of the site begins to diminish after a while. It will take anywhere from 5-10 minutes to return a result, where it used to take 2-3 seconds. If we restart the server, performance is returned, but over time, it degrades. Can you suggest what the causes could be of this declining performance? Are there issues with Access and Windows 2003? What are potential coding issues that should be looked at or examined?
As a footnote - this site used to exist on a Windows 2000 server, where it performed just fine. It was only when we moved to 2003 that we started seeing these issues arise -- the coding was unchanged.