Access driver settings

<< Click to Display Table of Contents >>

Navigation:  Configuration topics > BDE configuration settings > Drivers settings >

Access driver settings

Previous pageReturn to chapter overviewNext page

Applications that use BDE can now open or create Microsoft Access tables using the MSACCESS driver.To work with Access tables, choose MSACCESS as the driver name on the Configuration page of BDE Administrator and highlight the desired configuration parameter, or create or select an alias on the Databases page that uses MSACCESS as the driver name. Delete the old value and enter a new one in the appropriate text box. You can only change parameters WITHOUT bold labels.

In the following table, Parameters lists all tracked parameters for the selected driver type, and their current settings. When the driver is first installed, all values are set to their defaults.

Description briefly notes the purpose of the highlighted parameter.

Parameter

Description

VERSION

Internal version number of the Access driver.

TYPE

Type of server to which this driver helps you connect. Can be SERVER (SQL server) or FILE (standard, file-based server).

DLL32

The name of the driver's 32-bit Dynamic Link Library (*.DLL). Driver IDDA3532.DLL (default) for Access 97 and Jet Engine 3.5. Driver IDDAO32.DLL for Access 95 and Jet Engine 3.0.

DRIVER FLAGS

Internal product-specific flag. Do not change without direct instructions from Borland support personnel.

TRACE MODE

A numeric value (bit mask) specifying how much trace information to log. The Windows OutputDebugString call is used to output the requested information to the debug window. The following table shows which information is logged based on bit settings:

Bit Settings        Logged Information

0x0001        prepared query statement

0x0002        executed query statements

0x0004        vendor errors

0x0008        statement options (that is: allocate, free)

0x0010        connect / disconnect

0x0020        transaction

0x0040        BLOB I/O

0x0080        miscellaneous

0x0100        vendor calls

DATABASE NAME

The drive, path, and .MDB file name to access.

USER NAME

Default name for accessing the database.

OPEN MODE

Mode in which the driver connection opens the database. Can be READ/WRITE or READ ONLY. Default: READ/WRITE

LANGDRIVER

Language driver used to determine table sort order and character set.

SYSTEM DATABASE

Path and name of the system security database to be used when opening databases.  A change to this setting only takes effect when the driver is unloaded and then reloaded.