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

• Microsoft Access version 7.0

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.

1. Click the Start button, and then click Run.

2. In the Open box, type "regedit" (without the quotation marks).

3. Locate the HKEY_LOCAL_MACHINE registry folder.

4. Expand the HKEY_LOCAL_MACHINE folder until you locate the SOFTWARE\Microsoft\Jet\3.0\Engines folder.

5. Click Engines.

6. On the Edit Menu in the Registry Editor, click New, and then click Key.

7. Type "ODBC" (without the quotation marks), and then press ENTER.

8. 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)
   
   

9. 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.

10. 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.

11. 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.

1. In Program Manager, select File, Run.

2. Type "regedt32" (without the quotation marks).

3. Locate the HKEY_LOCAL_MACHINE registry folder.

4. Expand the HKEY_LOCAL_MACHINE folder until you locate SOFTWARE\Microsoft\Jet\3.0\Engines folder.

5. Click Engines.

6. From the Edit Menu in the Registry Editor, click Add Key.

7. Type "ODBC" (without the quotation marks) and press ENTER.

8. 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)
   
   

9. 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.

10. 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.

11. 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.

Keywords          : OdbcHowto kbusage
Version           : 7.0
Platform          : WINDOWS
Hardware          : x86
Issue type        : kbhowto