ACC: Upper Limit for QueryTimeout and LoginTimeout Parameters (100176)

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.