ACC: How to Set the QueryTimeOut Value for ODBC Connections

• Microsoft Access versions 7.0, 97

SUMMARY

IMPORTANT: This article contains information about editing the registry. Before you edit the registry, you should first make a backup copy of the registry files (System.dat and User.dat). Both are hidden files in the Windows folder.

Advanced: Requires expert coding, interoperability, and multiuser skills.

This article demonstrates how to set the QueryTimeOut property for queries run against ODBC Datasources.

MORE INFORMATION

When you're using an ODBC database, such as Microsoft SQL Server, there may be delays because of network traffic or heavy use of the ODBC server. Rather than waiting indefinitely, you can specify how long to wait before the Microsoft Jet database engine produces an error. The default QueryTimeOut property setting is 60 seconds. This setting may not be long enough to allow some queries to run against ODBC Data Sources. The following two methods demonstrate how to change the QueryTimeOut property.

Method 1

Create a subroutine to set the property:

1. Create and run the following subroutine when you open your database:

         Sub SetTimeout()
           Dim Mydb as Database
           Set Mydb=CurrentDB
           MYdb.Querytimeout=120
         End Sub
   
   

Method 2

Set the property in the Registry.

WARNING: Using Registry Editor incorrectly can cause serious problems that may require you to reinstall Windows. Microsoft cannot guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk.

For information about how to edit the registry, view the Changing Keys And Values online Help topic in Registry Editor (Regedit.exe). Note that you should make a backup copy of the registry files (System.dat and User.dat) before you edit the registry.

Using Microsoft Access 97

     HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\3.5\Engines\ODBC.