Article ID: 139044
Article Last Modified on 11/17/2000
APPLIES TO
- Microsoft Access 95 Standard Edition
This article was previously published under Q139044
IMPORTANT: This article contains information about editing the registry. Before you edit the registry, you should first make a backup copy of the registry files (System.dat and User.dat).
SUMMARY
Advanced: Requires expert coding, interoperability, and multiuser skills.
When troubleshooting ODBC connection issues or optimizing client/server performance, you often need to modify the ODBC settings in the ODBC section of the MSACC20.INI (or MSACCESS.INI in version 1.x). However, in Microsoft Access for Windows 95 version 7.0, a series of default values are pre-set. To force Microsoft Access to accept user-defined values for the ODBC settings, you need to add an ODBC Key and subsequent values to the Windows 95 Registry.
MORE INFORMATION
The \HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\3.0\Engines\ODBC folder contains initialization settings for the Microsoft Jet database engine. Before you can add any of the following values to the registry, you must create the ODBC folder under the Jet\3.0\Engines folder.
NOTE: Examples below are provided for both Windows 95 and Windows NT.
For Windows 95
For information about how to edit the registry, view the Changing Keys And Values online Help topic in Registry Editor (Regedit.exe). Note that you should make a backup copy of the registry files (System.dat and User.dat) before you edit the registry.
WARNING: Using Registry Editor incorrectly can cause serious problems that may require you to reinstall Windows 95. Microsoft cannot guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk.
- Click the Start button, and then click Run.
- In the Open box, type regedit.
- Locate the HKEY_LOCAL_MACHINE registry folder.
- Expand the HKEY_LOCAL_MACHINE folder until you locate the SOFTWARE\Microsoft\Jet\3.0\Engines folder.
- Click Engines.
- On the Edit Menu in the Registry Editor, click New, and then click Key.
- Type ODBC, and then press ENTER.
The following values can be created under the ODBC folder:
Name Type Default Value ------------------- ------ ----------------------------- LoginTimeout DWORD 20 QueryTimeout DWORD 60 ConnectionTimeout DWORD 600 AsyncRetryInterval DWORD 500 AttachCaseSensitive DWORD 00 (False) AttachableObjects String 'TABLE','VIEW','SYSTEM TABLE', 'ALIAS','SYNONYM' SnapshotOnly DWORD 00 (False) TraceSQLMode DWORD 00 (False) TraceODBCAPI DWORD 00 (False) DisableAsync DWORD 00 (False) TryJetAuth DWORD 01 (True) PreparedInsert DWORD 00 (False) PreparedUpdate DWORD 00 (False) FastRequery DWORD 00 (False)
- To add a new value, make sure that the ODBC key is highlighted, click the Edit menu, and then click New. On the menu that appears, you will see three Value Type choices: String, Binary, and DWORD. Click the type you want.
- A new value will be created in the right pane of the Registry window. Type in a new name for the value and press ENTER.
- With the new value still highlighted, click the Edit menu and click Modify. Type the new data for the value you have just created and click OK.
For Windows NT 3.51
For information about how to edit the registry, view the Changing Keys And Values online Help topic in Registry Editor (Regedit.exe). Note that you should make a backup copy of the registry files (System.dat and User.dat) before you edit the registry.
WARNING: Using Registry Editor incorrectly can cause serious problems that may require you to reinstall Windows 95. Microsoft cannot guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk.
- In Program Manager, select File, Run.
- Type regedt32.
- Locate the HKEY_LOCAL_MACHINE registry folder.
- Expand the HKEY_LOCAL_MACHINE folder until you locate SOFTWARE\Microsoft\Jet\3.0\Engines folder.
- Click Engines.
- From the Edit Menu in the Registry Editor, click Add Key.
- Type ODBC and press ENTER.
The following values can be created under the ODBC folder using the Edit Menu option Add Value:
Name Type Default Value ------------------- --------- ----------------------------- LoginTimeout REG_DWORD 20 QueryTimeout REG_DWORD 60 ConnectionTimeout REG_DWORD 600 AsyncRetryInterval REG_DWORD 500 AttachCaseSensitive REG_DWORD 00 (False) AttachableObjects REG_SZ 'TABLE','VIEW','SYSTEM TABLE', 'ALIAS','SYNONYM' SnapshotOnly REG_DWORD 00 (False) TraceSQLMode REG_DWORD 00 (False) TraceODBCAPI REG_DWORD 00 (False) DisableAsync REG_DWORD 00 (False) TryJetAuth REG_DWORD 01 (True) PreparedInsert REG_DWORD 00 (False) PreparedUpdate REG_DWORD 00 (False) FastRequery REG_DWORD 00 (False)
- To add a new value, make sure that the ODBC key is highlighted, click the Edit menu, and then click Add Key. Enter the name of the key in the Value Name text field, and then select the appropriate DataType from the above list.
- A new value will be created in the right pane of the Registry window. Type in a new name for the value and press ENTER.
- With the new value still highlighted, double-click the entry to modify the value.
REFERENCES
For more information about ODBC Registry Settings, search on the phrase "ODBC," and then view "Initializing the Microsoft ODBC Database Driver" using the Answer Wizard from the Microsoft Access for Windows 95 Help menu.
Additional query words: msacc20 ini
Keywords: kbhowto kbusage KB139044