anuneznyc
asked on
Access Queries Running Extremely Slow Over Network
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.
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Pat. Yes, I suppose we could shut down the Sonos box to see if that improves the speed of the queries.
What is the best way to benchmark the performance of the LAN?
What is the best way to benchmark the performance of the LAN?
I don't know. I develop Access apps. Hopefully you have a Network support person who should have the tools to check the LAN.
um unless I didn't understand correctly, I thought the Sonos box was a recent addition where as the problem has been long standing, no?
Jim.
Jim.
ASKER
Hi Jim. Not exactly. The problem has been long-standing, but the Sonos box is not that recent. I only just picked up this client, but I believe they have had the Sonos for about a year or so. The business owner thinks he recalls that the Access DB did start running more slowly shortly after the Sonos was added. So there may indeed be a direct correlation b/t the addition of the Sonos and the slowness.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Excellent idea, ALS315. Thank you!
ASKER
This has been an issue for a long time now. The one change the business owner is aware of is that they had a Sonos music player added to their network so they could stream music.
I will be onsite later today, so I can check the sizes of the tables.
How would I check on the indexing? And how can I view the SQL queries in Access?