Microsoft KB Archive/100176

= ACC: Upper Limit for QueryTimeout and LoginTimeout Parameters =

Article ID: 100176

Article Last Modified on 5/6/2003

-

APPLIES TO


 * Microsoft Access 1.0 Standard Edition
 * Microsoft Access 1.1 Standard Edition
 * Microsoft Access 2.0 Standard Edition

-



This article was previously published under Q100176



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

This article describes the maximum limit allowed for the QueryTimeout and LoginTimeout parameters.

For information about setting these values in Microsoft Access 95 and 97, please see the following article in the Microsoft Knowledge Base:

139044 ACC95: How to Add Former MSACC20.INI ODBC Section to Registry



MORE INFORMATION
In Microsoft Access 2.0, search the Help Index for MSACC20.INI to find information about the default settings in the [ODBC] section of the MSACC20.INI file.

As the README.TXT file for Microsoft Access 1.1 states, the two settings in the [ODBC] section of the MSACCESS.INI file are as follows:

 Entry              Value   Effect --- QueryTimeout        S      Wait S seconds for queries sent to                             ODBC, then stop trying to process the query results (for asynchronous                            queries only). Default: 60 seconds.

LoginTimeout        S      Wait S seconds for ODBC login response, and then stop trying to connect to a                            server. Default: 20 seconds.

However, the Microsoft Access 2.0 Help topic and Microsoft Access 1.x README.TXT file do not state the limits for these parameters.

Because the values for QueryTimeout and LoginTimeout are unsigned 4-byte values (long integers), the maximum value is +/- 2,147,483,648. If the value is set to zero, the timeout is disabled and the query or login never times out.

Keywords: kbhowto kbusage KB100176

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.