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


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 Problem:

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.

Thanks! 

Access Database Performs Slows on Windows 2003 Server

Windows Server 2003 was based on Windows XP and was released in four editions: Web, Standard, Enterprise and Datacenter. It also had derivative versions for clusters, storage and Microsoft’s Small Business Server. Important upgrades included integrating Internet Information Services (IIS), improvements to Active Directory (AD) and Group Policy (GP), and the migration to Automated System Recovery (ASR).