Microsoft KB Archive/139044

= ACC95: How to Add Former MSACC20.INI ODBC Section to Registry =

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.</li> Type ODBC, and then press ENTER.</li>  The following values can be created under the ODBC folder:

<pre class="fixed_text">      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) </li> 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.</li> 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.</li> 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.</li></ol>

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.

<ol> In Program Manager, select File, Run.</li> Type regedt32 .</li> Locate the HKEY_LOCAL_MACHINE registry folder.</li> Expand the HKEY_LOCAL_MACHINE folder until you locate SOFTWARE\Microsoft\Jet\3.0\Engines folder.</li> Click Engines.</li> From the Edit Menu in the Registry Editor, click Add Key.</li> Type ODBC and press ENTER.</li>  The following values can be created under the ODBC folder using the Edit Menu option Add Value:

<pre class="fixed_text">      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) </li> 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.</li> 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.</li> With the new value still highlighted, double-click the entry to modify the value.</li></ol>

<div class="references_section">