Xbase Engine Settings

The following table describes the registry settings that are installed for the Xbase engine. They are located in the \HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft
\Jet\3.5\Engines\Xbase key of the Windows registry. None of these settings are required.

Setting Data type Default value Description
NetworkAccess Boolean 01 Determines file locking preference. If the value of the NetworkAccess setting is 00 (False), tables are opened without any file locks, and records are added and edited without any record locks. This is appropriate only for single-user access.
PageTimeout Integer 600 The length of time between when data is placed in an internal cache and when it’s invalidated. The value is specified in 100 millisecond units.
INFPath String N/A The full path to the folder that contains the .inf file. Microsoft Jet first looks for an .inf file in the folder that contains the table. If the .inf file isn’t in the database folder, it looks in the INFPath. If no .inf file is found, the ISAM driver uses the production index file (.cdx or .mdx) for the table. This setting is not written by default.

Setting Data type Default value Description
CollatingSequence String ASCII The collating sequence for all dBASE tables created or opened using Microsoft Access. Possible values are ASCII and International.
DataCodePage String OEM The character set in which string and Memo values are stored. Possible values are OEM and ANSI. If the value of this setting is OEM, string values are translated from ANSI to OEM prior to being stored in the Xbase table. In the same manner, data retrieved from Xbase tables are translated from OEM to ANSI before being returned.
Deleted Boolean 01 Determines how records marked for deletion are handled by Microsoft Jet. 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.
Century Boolean 00 Used 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.
Date String MDY The date formatting style to use in cases where date-to-string functions are used in index expressions. The possible values for this setting, which correspond to the dBASE SET DATE command, are American, ANSI, British, French, DMY, German, Italian, Japan, MDY, USA, and YMD.
Mark Integer 0 The decimal value of the ASCII character used to separate date parts.
Exact Boolean 00 Used for date 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.
KanjiStr Boolean 00 00 means to treat strings as simple byte arrays. 01 means to treat strings as DBCS character strings. The KanjiStr setting is equivalent to the dBASE command SET KANJISTRING = ON. It affects the operation of the LEFT(), RIGHT(), SUBSTR(), AT(), REPLICATE(), and STUFF() functions inside the dBASE engine. A setting of 01 is recommended for DBCS countries.