Edit

Share via

Connection.QueryTimeout property (DAO)

  • Article

Applies to: Access 2013, Office 2013

Sets or returns a value that specifies the number of seconds to wait before a timeout error occurs when a query is executed on an ODBC data source.

Syntax

expression .QueryTimeout

expression A variable that represents a Connection object.

Remarks

The default value is 60.

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. Rather than waiting indefinitely, you can specify how long to wait.

When you use QueryTimeout with a Connection or Database object, it specifies a global value for all queries associated with the database. You can override this value for a specific query by setting the ODBCTimeout property of the particular QueryDef object.