Access Queries Running Extremely Slow Over Network
Posted on 2014-09-18
My client has a small business. They are running Windows Server 2012 and 5 workstations running mostly Windows 7 Professional, although one laptop is running Vista Business.
They have a customized database running on Access 2002, which keeps track of all their customers and order histories. The Access file is stored on a shared network drive.
They are complaining that running certain queries can take up to 30 seconds to process. I've compacted the database file, but the queries are still running very slowly.
I'm not sure if this is an Access issue or a LAN issue, or perhaps a combination of both. Was looking to get some advice on how to go about troubleshooting this. Thanks in advance.