Customize dBASE driver settings

Customize dBASE driver settings

  1. Start the Registry Editor.

    How?

  2. Navigate to the \HKEY_LOCAL_MACHINE
    \SOFTWARE\Microsoft\Jet\4.0\Engines\Xbase subkey and make the desired changes.

    For information on dBASE driver settings, click .

  3. Exit the Registry Editor.

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

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 2000, this includes Microsoft Excel 2000, Microsoft Visual Basic 6.0 or later, and possibly others. To make changes that apply only to Access 2000, navigate to the \HKEY_LOCAL_MACHINE\SOFTWARE
\Microsoft\Office\9.0\Access\Jet\4.0\Engines
\Xbase subkey, and then modify values there. If the \Xbase subkey does not exist, create the subkey, and then add the values.

Note   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. For more information, click .