BUG: Access Driver Ignores Pagetimeout in Datasources (155232)
The information in this article applies to:
- Microsoft Open Database Connectivity
This article was previously published under Q155232 SYMPTOMS
The Access ODBC driver ignores the Pagetimeout parameter specified in
ODBC datasources.
WORKAROUNDWARNING: Using Registry Editor incorrectly can cause serious, system-wide problems that may require you to reinstall Windows NT to correct them. Microsoft cannot guarantee that any problems resulting from the use of Registry Editor can be solved. Use this tool at your own risk.
To work around this problem:
- Run Registry Editor (Regedt32.exe).
- From the HKEY_LOCAL_MACHINE subtree, go to the following key:
\SOFTWARE\Microsoft\Jet\3.0\Engines
- From the Edit menu, select Add Key, and then enter the following key: Jet
- Select the Jet key.
- From the Edit menu, select Add Value.
- Add the following:
Value: PageTimeout
Data Type: REG_DWORD
Data: <Decimal value in milliseconds>
NOTE: If this value is set too low, performance may degrade due
to Jet increasing its reading of the .mdb file. Do not set the value lower
than the Jet 2.0 default of 0.5 second. The PageTimeout parameter is
expressed in 100 millisecond units. So, a value of 5 stands for 500
milliseconds or .5 seconds.
- Click OK.
- Quit Registry Editor.
- Shut down and restart Windows NT.
STATUS
Microsoft has confirmed this to be a problem in the ODBC Access 3.40.2829
Driver.
Modification Type: | Major | Last Reviewed: | 12/2/2002 |
---|
Keywords: | kbbug KB155232 kbAudDeveloper |
---|
|