MS Access 2003: Prevent a query from timing out
This MSAccess tutorial explains how to prevent a query from timing out in Access 2003 (with screenshots and step-by-step instructions).
See solution in other versions of Access:
Question: In Microsoft Access 2003, I keep getting an ODBC timeout error when I run my query. How can I prevent the query from timing out?
Answer: Open your query in design view. Then right-click in a blank area of the design view (where the tables are displayed) and select Properties from the popup menu.
When the "Query Properties" window appears, set the "ODBC Timeout" property to 0.
By default, it will be set to 60 which means that the query will timeout after 60 seconds. By changing the ODBC timeout value to 0, Access will never timeout.
This property is specific to the query that you are working on. So if you have any problems with other queries, you will need to repeat the same steps on each of those queries.
Advertisements