. You can use the ODBCTimeout property to specify the number of seconds Microsoft Access waits before a time-out error occurs when a query is run on an Open Database Connectivity (ODBC) database.
Setting
The ODBCTimeout property is an Integer value representing the number of seconds Microsoft Access waits. The default is 60 seconds. When this property is set to 0, no time-out error occurs.
You can set this property by using the query's property sheet or Visual Basic.
Remarks
When you're using an ODBC database, such as Microsoft SQL Server, there may be delays due to network traffic or heavy use of the ODBC server. The ODBCTimeout property lets you specify how long Microsoft Access waits for a network connection before a time-out error occurs.
For more information about accessing data in ODBC databases, see Chapter 15, "Retrieving and Analyzing Data," in the Microsoft Office 2000/Visual Basic Programer's Guide. For information about how to obtain the Microsoft Office 2000/Visual Basic Programer's Guide, click .