Access Run really Slow

G

Grace

I have a MS Access query on which the monthly report based. Every time it
takes about 5 minutes. But today it took about 40 minutes to run. The Access
is linked to tables on MS SQL server. What might be the problem?
 
J

John W. Vinson/MVP

Grace said:
I have a MS Access query on which the monthly report based. Every time it
takes about 5 minutes. But today it took about 40 minutes to run. The
Access
is linked to tables on MS SQL server. What might be the problem?
Click to expand...

Network load, other users hammering the SQL/Server instance, load balancing
problems on SQL, inappropriate indexes, different query parameters,
incorrect indexes or dropped indexes on the tables, a problem with the query
design... just for starters. Without knowing more about the situation it's
simply impossible to answer.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query on SQL Server is fast, while Access is crawling 2
Query takes 35 minutes to run with linked table. 2
Query Run Time 1
Query performance Access 2007 1
migration performance question 7
Error 3183 Not Enough Space on Temporary Disk 3
Access 2010 append query to SQL is very slow 0
Importing definitions only makes query super SLOW! 9

Top