MDAC 2.5 SDK - OLE DB Providers
OLE DB Provider for Microsoft Jet

Provider-Defined Properties in DBPROPSET_JETOLEDB_SESSION

The DBPROPSET_JETOLEDB_SESSION property set contains the following properties.

Property ID	Description
DBPROP_JETOLEDB_CONNECTIONCONTROL	Type: VT_I4 Typical R/W: R/W Description: Jet OLEDB:Connection Control Controls the ability to connect to the database. DBPROPVAL_JCC_PASSIVESHUTDOWN—Disallow new connections to the database. DBPROPVAL_JCC_NORMAL—Allow users to connect to the database.
DBPROP_JETOLEDB_EXCLUSIVEASYNCDELAY	Type: VT_I4 Typical R/W: R/W Description: Jet OLEDB:Exclusive Async Delay The maximum time Jet can delay asynchronous writes to disk, in milliseconds, when the database is opened exclusively. This property is ignored unless the DBPROP_JETOLEDB_FLUSHTRANSACTIONTIMEOUT property is 0.
DBPROP_JETOLEDB_FLUSHTRANSACTIONTIMEOUT	Type: VT_I4 Typical R/W: R/W Description: Jet OLEDB:Flush Transaction Timeout The amount of time of inactivity before the asynchronous write cache is flushed to disk. This setting precludes the values for Shared Async Delay and Exclusive Async Delay.
DBPROP_JETOLEDB_IMPLICITCOMMITSYNC	Type: VT_BOOL Typical R/W: R/W Description: Jet OLEDB:Implicit Commit Sync Determines whether changes made in internal implicit transactions are written in synchronous or asynchronous mode. VARIANT_TRUE—Changes are written synchronously. VARIANT_FALSE—Changes are written asynchronously.
DBPROP_JETOLEDB_LOCKDELAY	Type: VT_I4 Typical R/W: R/W Description: Jet OLEDB:Lock Delay This property determines how long to wait, in milliseconds, before attempting to acquire a lock after the previous attempt has failed.
DBPROP_JETOLEDB_LOCKRETRY	Type: VT_I4 Typical R/W: R/W Description: Jet OLEDB:Lock Retry The number of times to repeat attempts to access a locked page.
DBPROP_JETOLEDB_MAXBUFFERSIZE	Type: VT_I4 Typical R/W: R/W Description: Jet OLEDB:Max Buffer Size The largest amount of memory, in kilobytes, that Jet can use before it starts flushing changes to disk.
DBPROP_JETOLEDB_MAXLOCKSPERFILE	Type:VT_I4 Typical R/W: R/W Description: Jet OLEDB:Max Locks Per File The maximum number of locks that Jet can place on a database. The default for this property is 9500.
DBPROP_JETOLEDB_ODBCCOMMANDTIMEOUT	Type: VT_I4 Typical R/W: R/W Description: Jet OLEDB:ODBC Command Timeout Number of seconds before remote ODBC queries from Jet timeout.
DBPROP_JETOLEDB_PAGETIMEOUT	Type: VT_I4 Typical R/W: R/W Description: Jet OLEDB:Page Timeout The amount of time, in milliseconds, that Jet will wait before checking to see if its cache is out of date with the database file.
DBPROP_JETOLEDB_RECYCLELONGVALUEPAGES	Type: VT_BOOL Typical R/W: R/W Description: Jet OLEDB:Recycle Long-Valued Pages Whether Jet should aggressively try to reclaim BLOB pages when they are freed. VARIANT_TRUE—Long value pages will become available for reuse after Microsoft Jet determines that there is only one user in the database in shared mode and that new long value data has been added to the database. VARIANT_FALSE—Discarded long value pages will continue to occupy space in the database and become available for reuse only after the last user closes the database.
DBPROP_JETOLEDB_RESETISAMSTATS	Type: VT_BOOL Typical R/W: R/W Description: Jet OLEDB:Reset ISAM Stats Determines whether the schema rowset DBSCHEMA_JETOLEDB_ISAMSTATS should reset its performance counters after returning performance information. VARIANT_TRUE—Reset the ISAM performance counters to their initial values after generating the schema rowset. VARIANT_FALSE—Do not reset the ISAM performance counters.
DBPROP_JETOLEDB_SHAREDASYNCDELAY	Type: VT_I4 Typical R/W: R/W Description: Jet OLEDB:Shared Async Delay The maximum time Jet can delay asynchronous writes to disk, in milliseconds, when the database is opened in multiuser mode. This property is ignored unless the DBPROP_JETOLEDB_FLUSHTRANSACTIONTIMEOUT property is 0.
DBPROP_JETOLEDB_USERCOMMITSYNC	Type: VT_BOOL Typical R/W: R/W Description: Jet OLEDB:User Commit Sync Determines whether changes made in user explicit transactions are written in synchronous or asynchronous mode. VARIANT_TRUE—Changes are written synchronously. VARIANT_FALSE—Changes are written asynchronously.