query timeout

[Guest]

I am having problems with 1 query. I keep getting a timeout error. I have
changed the timeout value in the control panel on the data source, I have
changed the timeout under tools/options and I have also changed the timeout
value on the query itself and no matter what I do I continue to get the
timeout error. If I just run the sql qry for my report, it runs in no time
at all but when I try to display the report is where I keep getting the
message. Is there anything I can do. Also I am setting this up for the
users, what would I need to do on their end to prevent timeout message.

 

[John Spencer]

If the query runs quickly and returns all the records you expect (scroll
down to the bottom), then the problem is probably not the query. The
problem must be somewhere else.

Can you try rebuilding the report?

What processing is the report doing (if any)?

Are you sure the report's source is the query? Could it be using a
different query?

Try turning off Track name AutoCorrect.
(Tools: Options: General Uncheck all name AutoCorrect features)



--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..