Access database slow after move to Server 2008 R2
Posted on 2012-09-19
We have an access database around 50MB in size, which worked fine when hosted on Server 2003. We moved it to SBS2011 (Server 2008 R2) and now it's fine for a single user, but as soon as anyone else uses it as the same time, it becomes slow, taking at least 5 seconds to open a simply record which previously happened almost instantaneously.
As a test the data was moved to a Server 2003 virtual machine, and the problem was resolved. However we would like to host the data on the SBS2011 box natively, which I would expect to respond more quickly, especially from Windows 7 clients (it certainly is very fast for regular file access).
How can we improve the performance of the database while hosting it on Server 2008 R2 (SBS2011)? The database has been compacted already.
Thanks in advance.