Access: Prevent a query from timing out in Access 2000/97

Question:  In Access 2000/97, 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. Under the View menu, select Properties.

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.