When you install the dBASE database driver, the Setup program writes a set of default values to the Microsoft® Windows® Registry in the Engines and ISAM Formats subkeys. You should not modify these settings directly; use the setup program for your application to add, remove, or change these settings. The following sections describe initialization and ISAM format settings for the dBASE database driver.
The Paradox database driver will work in one of two modes, depending upon whether the Borland Database Engine (BDE) is installed. Paradox data is only updateable with the BDE. Without the BDE, the Paradox data can be Read, Exported, or Linked to read-only.
dBASE Initialization Settings
The Access Connectivity Engine\Engines\Xbase folder includes initialization settings for the Acexbe.dll driver, used for access to external dBASE data sources. Typical settings for the entries in this folder are shown in the following example.
win32=<path>\Acexbe.dll
NetworkAccess=On
PageTimeout=600
INFPath=C:\DBASE\SYSTEM
CollatingSequence=ASCII
DataCodePage=OEM
Deleted=On
DbcsStr=On
Century=Off
Date=MDY
Mark=47
Exact=Off
The Microsoft Access database engine uses the Xbase folder entries as follows.
Entry
Description
win32
The location of Msxbse35.dll. The full path is determined at the time of installation. Values are of type REG_SZ.
NetworkAccess
A binary indicator for file locking preference. If NetworkAccess is set to 00, tables are opened for exclusive access, regardless of the settings of the OpenDatabase and OpenRecordset methods' exclusive argument. The default value is 01. Values are of type REG_BINARY.
PageTimeout
The length of time between when data is placed in an internal cache and when it is invalidated. The value is specified in 100 millisecond units. The default is 600 units or 60 seconds. Values are of type REG_DWORD.
INFPath
The full path to the .inf file directory. The Microsoft Access database engine first looks for an .inf file in the directory containing the table. If the .inf file is not in the database directory, it looks in the INFPath. If there is no INFPath, it uses whatever index files (.cdx or .mdx) it finds in the database directory. Values are of type REG_SZ.
This entry is not written by the installation procedure.
CollatingSequence
This setting is only used if the BDE is not present on the machine.
The collating sequence for all dBASE tables created or opened using the Microsoft Access database engine. Possible values are ASCII and International. The default is ASCII. Values are of type REG_SZ.
DataCodePage
This setting is only used if the BDE is not present on the machine.
An indicator of how text pages are stored. Possible settings are:
OEM — OemToAnsi and AnsiToOem conversions done.
ANSI — OemToAnsi and AnsiToOem conversions not done.
The default is OEM. Values are of type REG_SZ.
Deleted
A binary indicator that determines how records marked for deletion are handled by the Microsoft Access database engine. A value of 01 corresponds to the dBASE command SET DELETED ON and indicates never to retrieve or position on a deleted record. A value of 00 corresponds to the dBASE command SET DELETED OFF and indicates to treat a deleted record like any other record. The default is 00. Values are of type REG_BINARY for Windows NT 3.51.
DbcsStr
A binary indicator that determines how the string functions will handle East Asia character set data. A value of 01 corresponds to the dBASE command SET KANJISTRING ON and indicates that strings should be treated as a dbcs character stream. A value of 00 indicates that strings should be treated as a simple byte stream.
Century
A binary indicator for formatting the century component of dates in cases where date-to-string functions are used in index expressions. A value of 01 corresponds to the dBASE command SET CENTURY ON and a value of 00 corresponds to the dBASE command SET CENTURY OFF. The default is 00. Values are of type REG_BINARY.
Date
The date formatting style to use in cases where date-to-string functions are used in index expressions. The possible settings for this entry, which corresponds to the dBASE SET DATE command, are American, ANSI, British, French, DMY, German, Italian, Japan, MDY, USA, and YMD. The default is MDY. Values are of type REG_SZ.
Mark
The decimal value of the ASCII character used to separate date parts. The default depends on the Date setting as follows:
"/" (American, MDY)
"." (ANSI)
"/" (British, French, DMY)
"." (German)
"-" (Italian)
"/" (Japan, YMD)
"-" (USA)
A value of 0 specifies that the system should use the separator usually associated with the selected date format.
The default is 0. Values are of type REG_DWORD.
Exact
A binary indicator for string comparisons. A value of 01 corresponds to the dBASE command SET EXACT ON. A value of 00 corresponds to the dBASE command SET EXACT OFF. The default is 00. Values are of type REG_BINARY..
dBASE ISAM Formats
The Access Connectivity Engine\ISAM Formats\dBASE III folder contains the following entries.
Entry name
Type
Value
Engine
REG_SZ
Xbase
ExportFilter
REG_SZ
dBASE III (*.dbf)
ImportFilter
REG_SZ
dBASE III (*.dbf)
CanLink
REG_BINARY
01
OneTablePerFile
REG_BINARY
01
IsamType
REG_DWORD
0
IndexDialog
REG_BINARY
01
IndexFilter
REG_SZ
dBASE Index (*.ndx)
CreateDBOnExport
REG_BINARY
00
ResultTextImport
REG_SZ
Import data from the external file into the current database. Changing data in the current database will not change data in the external file.
ResultTextLink
REG_SZ
Create a table in the current database that is linked to the external file. Changing data in the current database will change data in the external file.
ResultTextExport
REG_SZ
Export data from the current database into a dBASE III file. This process will overwrite the data if exported to an existing file.
SupportsLongNames
REG_BINARY
00
The Access Connectivity Engine\ISAM Formats\dBASE IV folder contains the following entries.
Entry name
Type
Value
Engine
REG_SZ
Xbase
ExportFilter
REG_SZ
dBASE IV (*.dbf)
ImportFilter
REG_SZ
dBASE IV (*.dbf)
CanLink
REG_BINARY
01
OneTablePerFile
REG_BINARY
01
IsamType
REG_DWORD
0
IndexDialog
REG_BINARY
01
IndexFilter
REG_SZ
dBASE Index (*.ndx; *.mdx)
CreateDBOnExport
REG_BINARY
00
ResultTextImport
REG_SZ
Import data from the external file into the current database. Changing data in the current database will not change data in the external file.
ResultTextLink
REG_SZ
Create a table in the current database that is linked to the external file. Changing data in the current database will change data in the external file.
ResultTextExport
REG_SZ
Export data from the current database into a dBASE IV file. This process will overwrite the data if exported to an existing file.
SupportsLongNames
REG_BINARY
00
The Access Connectivity Engine\ISAM Formats\dBASE 5.0 folder contains the following entries.
Entry name
Type
Value
Engine
REG_SZ
Xbase
ExportFilter
REG_SZ
dBASE 5 (*.dbf)
ImportFilter
REG_SZ
dBASE 5 (*.dbf)
CanLink
REG_BINARY
01
OneTablePerFile
REG_BINARY
01
IsamType
REG_DWORD
0
IndexDialog
REG_BINARY
01
IndexFilter
REG_SZ
dBASE Index (*.ndx; *.mdx)
CreateDBOnExport
REG_BINARY
00
ResultTextImport
REG_SZ
Import data from the external file into the current database. Changing data in the current database will not change data in the external file.
ResultTextLink
REG_SZ
Create a table in the current database that is linked to the external file. Changing data in the current database will change data in the external file.
ResultTextExport
REG_SZ
Export data from the current database into a dBASE 5 file. This process will overwrite the data if exported to an existing file.
SupportsLongNames
REG_BINARY
00
Note
When you change Windows Registry settings, you must exit and then restart the database engine for the new settings to take effect.