Provider-Defined Properties in DBPROPSET_JETOLEDB_DBINIT

Typical R/W: R/W

Description: Jet OLEDB:Don't Copy Locale on Compact

Tells Jet not to copy locale information when compacting a database using IJetCompact::Compact. This property is used to make sure that the resultant database has homogeneous locale information across all tables and indexes.

Typical R/W: R/W

Description: Jet OLEDB:Compact Without Relationships

Determines whether IJetCompact::Compact should copy relationships into the newly compacted database: 

• VARIANT_TRUE—Compact will not copy relationships into the resultant database.
  
  
• VARIANT_FALSE—Compact will copy relationships.

Other routines in the Jet Provider that accept properties from the Initialization property group ignore this property.

Typical R/W: R/W

Description: Jet OLEDB:Compact Without Replica Repair

Determines whether IJetCompact::Compact should attempt to repair damaged replicas by looking for other databases with which it can synchronize.

Typical R/W: R/W

Description: Jet OLEDB:Create System Database

Determines whether IDBDataSourceAdmin::CreateDataSource generates a system database:

• VARIANT_TRUE—Generate a system database.
  
  
• VARIANT_FALSE—Generate a regular database.

In general, users will rarely want to generate system databases. This property is ignored when connecting to a preexisting database.

Typical R/W: R/W

Description: Jet OLEDB:Database Locking Mode

Scheme to use when locking the database.

Constants:

• DBPROPVAL_DL_OLDMODE—Old mode used in previous releases of Jet's storage engine
  
  
• DBPROPVAL_DL_ALCATRAZ—Alcatraz mode. Enables locking mode that allows for row-level locking. This does not preclude page locking.

A database can be open in only one mode at a time. The first user to open the database determines the locking mode used while the database is open.

Typical R/W: R/W

Description: Jet OLEDB:Database Password

Password used to open the database. This differs from the user password in that the database password is per file, while a user password is per user.

Typical R/W: R/W

Description: Jet OLEDB:Encrypt Database

Determines whether IJetCompact::Compact should encrypt the resultant compacted database: 

• VARIANT_TRUE—Encrypt the resultant database.
  
  
• VARIANT_FALSE—Do not encrypt the resultant database. If the database to be compressed is currently encrypted, this will remove that encryption.

This property defaults to the current value of the database. Not setting this property should retain the database's current setting.

Typical R/W: R/W

Description: Jet OLEDB:Engine Type

An enumeration defining the storage engine currently in use to access this database/data store.

Constants:

JET_ENGINETYPE_UNKNOWN = 0

JET_ENGINETYPE_JET10 = 1

JET_ENGINETYPE_JET11 = 2

JET_ENGINETYPE_JET2X = 3

JET_ENGINETYPE_JET3X = 4

JET_ENGINETYPE_JET4X = 5

JET_ENGINETYPE_DBASE3 = 10

JET_ENGINETYPE_DBASE4 = 11

JET_ENGINETYPE_DBASE5 = 12

JET_ENGINETYPE_EXCEL30 = 20

JET_ENGINETYPE_EXCEL40 = 21

JET_ENGINETYPE_EXCEL50 = 22

JET_ENGINETYPE_EXCEL80 = 23

JET_ENGINETYPE_EXCEL90 =24

JET_ENGINETYPE_EXCHANGE4 = 30

JET_ENGINETYPE_LOTUSWK1 = 40

JET_ENGINETYPE_LOTUSWK3 = 41

JET_ENGINETYPE_LOTUSWK4 = 42

JET_ENGINETYPE_PARADOX3X = 50

JET_ENGINETYPE_PARADOX4X = 51

JET_ENGINETYPE_PARADOX5X = 52

JET_ENGINETYPE_PARADOX7X = 53

JET_ENGINETYPE_TEXT1X = 60

JET_ENGINETYPE_HTML1X = 70

When calling IDBDataSourceAdmin::CreateDataSource, this can be used to specify the format for the new database.

Once a database has been opened, this property can be read to determine what file version is open.

Typical R/W: R/W

Description: Jet OLEDB:Global Bulk Transactions

Determines whether SQL bulk operations are transacted. This property determines the default for all operations in the current connection.

• DBPROPVAL_BT_NOBULKTRANSACTIONS—Bulk operations are not allowed.
  
  
• DBPROPVAL_BT_BULKTRANSACTION—Bulk operations are transacted.

Typical R/W: R/W

Description: Jet OLEDB:Global Partial Bulk Ops

This property determines the behavior of Jet when SQL DML bulk operations fail. It can be overridden on a per-rowset basis by setting the DBPROP_JETOLEDB_BULKPARTIAL property.

Constants:

• JET_BULKPARTIAL_NOPARTIAL—Fail the bulk operation on a single error.
  
  
• JET_BULKPARTIAL_PARTIAL—Allow partial completion of the bulk operation. Could result in inconsistent changes since operations on some rows could succeed and others could fail.
  
  
• JET_BULKPARTIAL_NOPARTIAL = 2— Fail the bulk operation on a single error.

Typical R/W: R/W

Description: Jet OLEDB:New Database Password

When calling IDBDataSourceAdmin::ModifyDataSource, this property allows the user to change a database password. The current password is set in DBPROP_JETOLEDB_DATABASEPASSWORD, while the new password is set in this property. If the call is successful, DBPROP_JETOLEDB_DATABASEPASSWORD will reflect the new database password.

Typical R/W: R/W

Description: Jet OLEDB:Registry Path

Path to the registry key to use for Jet information. This does not include the HKEY_LOCAL_MACHINE tag. This value can be changed to a secondary location to store registry values for a particular application—values that are not shared with other applications that use Jet on the computer.

Typical R/W: R/W

Description: Jet OLEDB:System database

Location for the Jet system database to use for authenticating users. This overrides the value set in the registry or the corresponding systemdb registry key used when DBPROP_JETOLEDB_REGPATH is used. This can include the path to the file.