Microsoft KB Archive/100176

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 15:01, 18 July 2020 by 3155ffGd (talk | contribs) (importing KB archive)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Knowledge Base

ACC: Upper Limit for QueryTimeout and LoginTimeout Parameters

Article ID: 100176

Article Last Modified on 5/6/2003


  • 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


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


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