MS Access Database slow to search database remotely
Posted on 2009-07-16
I have 40mb access database that I have on my local lan. I am able to do a search on it and get a result immediately.
When my colleagues in another building try to do the same, their search will take 5 minutes to get a result or the client will hang. They are connected to us via a 2 MB MPLS link and when I tested there was 1.8mb free bandwidth.
I ran a ping -t from the client machine to the server where the database sits and noticed that while the search was running the ping results changed from 1ms to 100ms erratically. As soon as I killed off MS Access, the client machine sat at a permanent 3ms.
I have done the usual stuff and compacted database etc, but still no joy.
Any ideas where I could start looking