Customize driver settings

Microsoft Office Access 2003

previous page next page
  • 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.

    • ShowCustomize text driver settings

    1. Start the Registry Editor.

      ShowHow?

      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\11.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\Text 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 text data. In addition to Microsoft Access, this includes Microsoft Excel and Microsoft Visual Basic 6.0 or later.

      To make changes that apply only to Microsoft Office Access 2003, navigate to the \HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\11.0\Access\Jet\4.0\Engines\Text subkey, and then modify values there. If the \Text 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.

    ShowCustomize Microsoft Excel driver settings

    1. Start the Registry Editor.

      ShowHow?

      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\11.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\Excel 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 Excel data. In addition to Microsoft Access, this includes Microsoft Excel and Microsoft Visual Basic 6.0 or later.

      To make changes that apply only to Office Access 2003, navigate to the \HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\11.0\Access\Jet\4.0\Engines\Excel subkey, and then modify values there. If the \Excel 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.

    ShowCustomize dBASE driver settings

    1. Start the Registry Editor.

      ShowHow?

      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\11.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\Xbase subkey and make the desired changes.

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

      To make changes that apply only to Microsoft Office Access 2003, navigate to the \HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\11.0\Access\Jet\4.0\Engines\dBASE subkey, and then modify values there. If the \dBASE 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.

    ShowCustomize Paradox driver settings

    1. Start the Registry Editor.

      ShowHow?

      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\11.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\Paradox 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 Paradox data. In addition to Microsoft Access, this includes Microsoft Excel and Microsoft Visual Basic 6.0 or later.

      To make changes that apply only to Microsoft Office Access 2003, navigate to the \HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\11.0\Access\Jet\4.0\Engines\Paradox subkey, and then modify values there. If the \Paradox 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.

    ShowCustomize Lotus driver settings

    1. Start the Registry Editor.

      ShowHow?

      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\11.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\Lotus 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 Lotus 1-2-3 data. In addition to Microsoft Access, this includes Microsoft Excel and Microsoft Visual Basic 6.0 or later.

      To make changes that apply only to Microsoft Office Access 2003, navigate to the \HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\11.0\Access\Jet\4.0\Engines\Lotus subkey, and then modify values there. If the \Lotus 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.

    ShowCustomize Microsoft Exchange driver settings

    1. Start the Registry Editor.

      ShowHow?

      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\11.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\Exchange 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 Exchange data. In addition to Microsoft Access, this includes Microsoft Excel and Microsoft Visual Basic 6.0 or later.

      To make changes that apply only to Microsoft Office Access 2003, navigate to the \HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\11.0\Access\Jet\4.0\Engines\Exchange subkey, and then modify values there. If the \Exchange 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.

    ShowCustomize ODBC driver settings

    1. Start the Registry Editor.

      ShowHow?

      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\11.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\ODBC 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 ODBC databases. In addition to Microsoft Access, this includes Microsoft Excel and Microsoft Visual Basic 6.0 or later.

      To make changes that apply only to Microsoft Office Access 2003, navigate to the \HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\11.0\Access\Jet\4.0\Engines\ODBC subkey, and then modify values there. If the \ODBC 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.

    ShowCustomize HTML driver settings

    1. Start the Registry Editor.

      ShowHow?

      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\11.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\Text 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 HTML data. In addition to Microsoft Access, this includes Microsoft Excel and Microsoft Visual Basic 6.0 or later.

      To make changes that apply only to Microsoft Office Access 2003, navigate to the \HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\11.0\Access\Jet\4.0\Engines\Text subkey, and then modify values there. If the \Text 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.
    previous page start next page