ACC2000: How to Set the QueryTimeout Value for ODBC Connections

This article was previously published under Q208386
This article has been archived. It is offered "as is" and will no longer be updated.
This article applies only to a Microsoft Access database (.mdb).

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

IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:
256986 Description of the Microsoft Windows Registry
SUMMARY
This article demonstrates how to set the QueryTimeout property for queries run against ODBC data sources.
MORE INFORMATION
When you use 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 wait indefinitely, you can specify how long to wait beforethe Microsoft Jet database engine returns an error. The defaultQueryTimeout property setting is 60 seconds. This setting may not be long enough to allow some queries to run against ODBC data sources. Thefollowing steps demonstrate how to change the QueryTimeout property.

NOTE: When you set the QueryTimeout value within the registry, any new and existing queries within Microsoft Access continue to display a value of 60 for the QueryTimeout property. If the value you set within the registry is greater than the value defined within the individual query, Microsoft Access uses the value within the registry to determine how long to wait before a QueryTimeout occurs.

WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.
  1. Locate the following registry key:
    HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\ODBC
  2. Click to highlight QueryTimeout, and then on the Edit menu, click Modify. Change the DWORD value to the setting that you want. The value represents the number of seconds to timeout.
REFERENCES
For additional information about backing up the system registry, please click the article number below to view the article in the Microsoft Knowledge Base:
135120 Configuration Backup Tool for Backing Up the Registry
Properties

Article ID: 208386 - Last Review: 12/05/2015 10:52:24 - Revision: 2.0

Microsoft Access 2000 Standard Edition

  • kbnosurvey kbarchive kbhowto kbusage KB208386
Feedback