Customize Jet database settings

Caution   Many Microsoft Access registry settings are added automatically when you install Microsoft Access. Changing the installed settings can produce unexpected results, which may make it necessary to reinstall Microsoft Access. It is strongly recommended that you not change settings in the Microsoft Windows registry. However, if you must change registry settings or options, use the Windows Registry Editor, and change only those settings or options that are explicitly documented. The revised settings take effect the next time you start Microsoft Access. It is recommended that you back up all of the registry, or at least the part you will be editing. For information, look up "backing up the registry" in the index of the Registry Editor Help.

Notes

• Microsoft Jet database engine settings apply only to Microsoft Access databases, not to Microsoft Access projects.
• You can also use the Data Access Object (DAO) method, Application.DBEngine.SetOption to dynamically modify Microsoft Jet registry values at run-time for a single session, without permanently modifying the values in the Windows registry.

Customize Microsoft Jet version 2.x database engine settings

1. Start the Registry Editor.

   How?

   1. To run the Registry Editor, click the Microsoft Windows Start button, click Run, type regedit, and then click OK.
   2. Navigate to the appropriate registry subkey. The two main subkeys that contain settings that affect Microsoft Access are:

      \HKEY_LOCAL_MACHINE\SOFTWARE
      \Microsoft\Office\10.0\Access

      \HKEY_LOCAL_MACHINE\SOFTWARE
      \Microsoft\Jet\4.0

      If there is a plus (+) to the left of the subkey, that registry subkey contains additional subkeys. To edit a registry subkey's value, double-click the subkey in the left pane of the Registry Editor window to open it, and then double-click the value you want to edit in the right pane of the Registry Editor window. In some cases, you may need to add new subkeys or values. For information on how to add new subkeys and values, use the Registry Editor Help.

2. Do one of the following:

   To make changes to the Microsoft Jet database engine, navigate to the \HKEY_LOCAL_MACHINE
   \SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 2.x subkey and make the desired changes.

   Important   Changes to settings in this subkey will affect all programs installed on the computer that use the Microsoft Jet database engine to access Microsoft Access 1.x and 2.0 databases. In addition to Microsoft Access, this includes Microsoft Excel and Microsoft Visual Basic.

   To make changes that apply only to Microsoft Access 2002, navigate to the \HKEY_LOCAL_MACHINE\SOFTWARE
   \Microsoft\Office\10.0\Access\Jet\4.0\Engines
   \Jet 2.x subkey, and then modify values there. If the \Jet 2.x subkey does not exist, create the subkey, and then add the values.

3. Exit the Registry Editor.
4. Exit and restart Microsoft Access to use the new settings.

Customize Microsoft Jet version 3.x database engine settings

1. Start the Registry Editor.

   How?

   1. To run the Registry Editor, click the Microsoft Windows Start button, click Run, type regedit, and then click OK.
   2. Navigate to the appropriate registry subkey. The two main subkeys that contain settings that affect Microsoft Access are:

      \HKEY_LOCAL_MACHINE\SOFTWARE
      \Microsoft\Office\10.0\Access

      \HKEY_LOCAL_MACHINE\SOFTWARE
      \Microsoft\Jet\4.0

      If there is a plus (+) to the left of the subkey, that registry subkey contains additional subkeys. To edit a registry subkey's value, double-click the subkey in the left pane of the Registry Editor window to open it, and then double-click the value you want to edit in the right pane of the Registry Editor window. In some cases, you may need to add new subkeys or values. For information on how to add new subkeys and values, use the Registry Editor Help.

2. Do one of the following:

   To make changes to the Microsoft Jet database engine, navigate to the \HKEY_LOCAL_MACHINE
   \SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 3.x subkey and make the desired changes.

   Important   Changes to settings in this subkey will affect all programs installed on the computer that use the Microsoft Jet database engine to access Microsoft Access 95 or Microsoft Access 97 databases. In addition to Microsoft Access, this includes Microsoft Excel and Microsoft Visual Basic.

   To make changes that apply only to Microsoft Access 2002, navigate to the \HKEY_LOCAL_MACHINE\SOFTWARE
   \Microsoft\Office\10.0\Access\Jet\4.0\Engines
   \Jet 3.x subkey, and then modify values there. If the \Jet 3.x subkey does not exist, create the subkey, and then add the values.

3. Exit the Registry Editor.
4. Exit and restart Microsoft Access to use the new settings.

Customize Microsoft Jet version 4.0 database engine settings

1. Start the Registry Editor.

   How?

   1. To run the Registry Editor, click the Microsoft Windows Start button, click Run, type regedit, and then click OK.
   2. Navigate to the appropriate registry subkey. The two main subkeys that contain settings that affect Microsoft Access are:

      \HKEY_LOCAL_MACHINE\SOFTWARE
      \Microsoft\Office\10.0\Access

      \HKEY_LOCAL_MACHINE\SOFTWARE
      \Microsoft\Jet\4.0

      If there is a plus (+) to the left of the subkey, that registry subkey contains additional subkeys. To edit a registry subkey's value, double-click the subkey in the left pane of the Registry Editor window to open it, and then double-click the value you want to edit in the right pane of the Registry Editor window. In some cases, you may need to add new subkeys or values. For information on how to add new subkeys and values, use the Registry Editor Help.

2. Do one of the following:

   To make changes to the Microsoft Jet database engine, navigate to the \HKEY_LOCAL_MACHINE
   \SOFTWARE\Microsoft \Jet\4.0\Engines\Jet 4.0 subkey and make the desired changes.

   Important   Changes to settings in this subkey will affect all programs installed on the computer that use the Microsoft Jet database engine to access Microsoft Access 2002 databases. In addition to Microsoft Access, this includes Microsoft Excel 2002 and Microsoft Visual Basic 6.0 or later.

   To make changes that apply only to Microsoft Access 2002, navigate to the \HKEY_LOCAL_MACHINE\SOFTWARE
   \Microsoft\Office\10.0\Access\Jet\4.0\Engines
   \Jet 4.0 subkey, and then modify values there. If the \Jet 4.0 subkey does not exist, create the subkey, and then add the values.

3. Exit the Registry Editor.
4. Exit and restart Microsoft Access to use the new settings.