Query Timeout error in Access 2010

I am using Access 2010. If I run a query I get my results back. If I run the report attached to that query I get [Microsoft][ODBC SQL Server Driver]Timeout expired #0 after 60 seconds.

If I keep trying to run the report it will eventually work. This problem has made my macro to run these reports automatically useless.

Any ideas?
Who is Participating?
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
If you have a complex Report or recordset, this can happen.

It can also happen because of the normal delays of gathering data for the backend.

You can shorten the time,... (in the Access Options)
...just remember that the more often you refresh (the shorter the time), the more resources you will use in constantly getting this data...

Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
Base the report on a query, then set the query's ODBCTimeout property to a longer value, or 0 which is no timeout.

Jeffrey CoachmanMIS LiasonCommented:
Jim's post is also valid here, perhaps even more so than my post...
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.