The following sections describe initialization settings for the Microsoft Jet 3.5 database engine.
When MSJET35.DLL and MSRD2X35.DLL are registered, two entries are written to the \HKEY_LOCAL_MACHINES\Software\Microsoft\ Jet\3.5\Engines folder. This is done automatically when Microsoft Access 97 is installed. These two entries are the following:
SystemDB = <path>\System.mdb
CompactByPkey = 1
The Microsoft Jet database engine uses the following entries.
| Entry | Description |
| SystemDB | Specifies the full path and file name of the workgroup information file. The default is the appropriate path followed by the file name System.mdb. Values are of type String for Windows 95 and Windows NT 4.0, and of type REG_SZ for Windows NT 3.51. |
| CompactByPKey | Specifies that when you compact tables they are copied in primary-key order, if a primary key exists on the table. If no primary key exists on a table, the tables are copied in base-table order.
A value of 0 indicates that tables should be compacted in base-table order; a non-zero value indicates that tables should be compacted in primary-key order, if a primary key exists. The default value is non-zero. Values are of type DWORD for Windows 95 and Windows NT 4.0, and of type REG_DWORD for Windows NT 3.51. Note This setting only applies to compacting databases created with the Microsoft Jet database engine version 3.0 or later; when you compact databases created with the Microsoft Jet database engine version 2.x, the data is always copied in the order of the base table. |