Provider-Defined Properties in DBPROPSET_JETOLEDB_DBINIT

Provider-Defined Properties in DBPROPSET_JETOLEDB_DBINIT

The following table lists and describes DBPROPSET_JETOLEDB_DBINIT properties that are specific to the OLE DB Provider for Microsoft Jet.

Property ID	Description
DBPROP_JETOLEDB_COMPACT_DONTCOPYLOCALE	Type: VT_BOOL 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 usingIJetCompact::Compact. This property is used to make sure that the resultant database has homogeneous locale information across all tables and indexes.
DBPROP_JETOLEDB_COMPACT_NORELATIONSHIPS	Type: VT_BOOL Typical R/W: R/W Description: Jet OLEDB:Compact Without Relationships Determines whether IJetCompact::Compactshould 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.
DBPROP_JETOLEDB_COMPACT_NOREPAIRREPLICAS	Type: VT_BOOL Typical R/W: R/W Description: Jet OLEDB:Compact Without Replica Repair Determines whether IJetCompact::Compactshould attempt to repair damaged replicas by looking for other databases with which it can synchronize.
DBPROP_JETOLEDB_CREATESYSTEMDATABASE	Type: VT_BOOL Typical R/W: R/W Description: Jet OLEDB:Create System Database Determines whetherIDBDataSourceAdmin::CreateDataSourcegenerates 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.
DBPROP_JETOLEDB_DATABASELOCKMODE	Type: VT_I4 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.
DBPROP_JETOLEDB_DATABASEPASSWORD	Type: VT_BSTR 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.
DBPROP_JETOLEDB_ENCRYPTDATABASE	Type: VT_BOOL Typical R/W: R/W Description: Jet OLEDB:Encrypt Database Determines whether IJetCompact::Compactshould 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.
DBPROP_JETOLEDB_ENGINE	Type: VT_I4 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 callingIDBDataSourceAdmin::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.
DBPROP_JETOLEDB_GLOBALBULKNOTRANSACTIONS	Type: VT_I4 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.
DBPROP_JETOLEDB_GLOBALBULKPARTIAL	Type: VT_I4 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.
DBRPOP_JETOLEDB_NEWDATABASEPASSWORD	Type: VT_BSTR Typical R/W: R/W Description: Jet OLEDB:New Database Password When callingIDBDataSourceAdmin::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.
DBPROP_JETOLEDB_REGPATH	Type: VT_BSTR 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.
DBPROP_JETOLEDB_SYSDBPATH	Type: VT_BSTR 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.