ACC: OpenDatabase Method does not Use Jet LoginTimeout Setting (195946)
The information in this article applies to:
- Microsoft Access for Windows 95 7.0
- Microsoft Access 97
This article was previously published under Q195946
IMPORTANT: This article contains information about editing the registry.
Before you edit the registry, make sure you understand how to restore it if
a problem occurs. For information about how to do this, view the "Restoring
the Registry" Help topic in Regedit.exe or the "Restoring a Registry Key"
Help topic in Regedt32.exe.
Moderate: Requires basic macro, coding, and interoperability skills.
SYMPTOMS
The default ODBC LoginTimeout property setting for Microsoft Jet databases
is 20. Depending on which version of Microsoft Access you have, the ODBC
LoginTimeout setting is stored in the following registry key.
In Microsoft Access 97
----------------------
HKEY_LOCAL_MACHINE\SOFTWARE
Microsoft\Jet\3.5\Engines\ODBC\LoginTimeout
In Microsoft Access 7.0
-----------------------
HKEY_LOCAL_MACHINE\SOFTWARE
Microsoft\Jet\3.0\Engines\ODBC\LoginTimeout
You can change the ODBC LoginTimeout property value from the default of 20;
however, the new value that you set will not be used in the OpenDatabase
method of the current database, as in the following line:
Set db=OpenDatabase("",false,false,"odbc;DSN=TEST" )
RESOLUTION
If you have changed the registry key to something other than the default of
20, and you want to use that new value with the OpenDatabase method, you
should include the DBEngine object, as in the following line:
set db=DBEngine.OpenDatabase("",false,false,"odbc;DSN=TEST" )
STATUS
Microsoft has confirmed this to be a problem in the versions of Microsoft
Access listed at the beginning of this article.
Modification Type: | Major | Last Reviewed: | 11/21/2003 |
---|
Keywords: | kbbug kbnofix KB195946 |
---|
|