Customizing Windows Registry Settings for Microsoft Jet

If your application cannot work correctly with the default functionality of the Microsoft Jet database engine , you may have to change the settings in the Microsoft® Windows® Registry to suit your needs. The Windows Registry can also be used to tune the operation of the installable ISAM and ODBC driver .

You can customize the settings in the Windows Registry in four different ways:

Using Regedit.exe to Overwrite the Default Settings

Creating a Portion in Your Application’s Registry Tree to Manage the Settings

Using the SetOption Method from DAO

Using the Connection Properties in the Microsoft OLE DB Provider for Jet

You can also edit the Windows Registry to specify the following:

• Settings used for interaction with Microsoft Excel, Lotus, Paradox, and dBASE databases. See Initializing the Paradox Database Driver , Initializing the Microsoft Excel Driver , Initializing the Lotus Driver , and Initializing the dBASE Database Driver .
• Settings used by Microsoft ODBC for interaction with SQL databases. See Initializing the Microsoft ODBC Database Driver .
• Settings that affect how the Microsoft Jet database engine reads and saves data. See Initializing the Microsoft Jet 2.5 Database Engine Driver , Initializing the Microsoft Jet 3.5 Database Engine Driver , and Initializing the Microsoft Jet 4.0 Database Engine Driver .
• Settings used to control how the Microsoft Jet database engine interacts with the Internet and Microsoft Exchange. See Initializing the Text and HTML Data Source Driver and Initializing the Microsoft Exchange Data Source Driver .
• Settings used to control how the Microsoft Jet database engine interacts with data imported as plain text. See Initializing the Text and HTML Data Source Driver .