Appendix C: Microsoft Jet 4.0 OLE DB Provider-Defined Property Values

The Microsoft Jet Provider defines a number of GUIDs and property values that are for provider-specific features and properties. Because they are provider-specific values, ADO does not expose them in enumeration values or constants.

Use the attached file, JetOLEDBConstants.bas, or copy and paste the following code into a module in your project, to make working with these values easier in a Visual Basic for Applications development environment.

Attribute VB_Name = "JetOLEDBConstants"
Option Explicit

'  Microsoft Jet         OLEDB:Engine Type property values
Global Const JET_ENGINETYPE_UNKNOWN = 0
Global Const JET_ENGINETYPE_JET10 = 1
Global Const JET_ENGINETYPE_JET11 = 2
Global Const JET_ENGINETYPE_JET20 = 3
Global Const JET_ENGINETYPE_JET3X = 4
Global Const JET_ENGINETYPE_JET4X = 5
Global Const JET_ENGINETYPE_DBASE3 = 10
Global Const JET_ENGINETYPE_DBASE4 = 11
Global Const JET_ENGINETYPE_DBASE5 = 12
Global Const JET_ENGINETYPE_EXCEL30 = 20
Global Const JET_ENGINETYPE_EXCEL40 = 21
Global Const JET_ENGINETYPE_EXCEL50 = 22
Global Const JET_ENGINETYPE_EXCEL80 = 23
Global Const JET_ENGINETYPE_EXCEL90 = 24
Global Const JET_ENGINETYPE_EXCHANGE4 = 30
Global Const JET_ENGINETYPE_LOTUSWK1 = 40
Global Const JET_ENGINETYPE_LOTUSWK3 = 41
Global Const JET_ENGINETYPE_LOTUSWK4 = 42
Global Const JET_ENGINETYPE_PARADOX3X = 50
Global Const JET_ENGINETYPE_PARADOX4X = 51
Global Const JET_ENGINETYPE_PARADOX5X = 52
Global Const JET_ENGINETYPE_PARADOX7X = 53
Global Const JET_ENGINETYPE_TEXT1X = 60
Global Const JET_ENGINETYPE_HTML1X = 70

'       Microsoft Jet OLEDB:Global Partial Bulk Ops and 
' Microsoft Jet OLEDB:Partial Bulk Ops property values
Global Const JET_BULKPARTIAL_DEFAULT = 0
Global Const JET_BULKPARTIAL_PARTIAL = 1                                   
Global Const JET_BULKPARTIAL_NOPARTIAL = 2                 

' Jet OLEDB:Global Bulk Transactions  and
' Jet OLEDB:Bulk Transactions property values
Global Const JET_BULKTRAN_DEFAULT = 0 'not valid for Global
Global Const JET_BULKTRAN_NOBULK = 1
Global Const JET_BULKTRAN_BULK = 2

'        Microsoft Jet OLEDB:Database Locking Mode property values
Global Const JET_DATABASELOCKMODE_PAGE = 0
Global Const JET_DATABASELOCKMODE_ROW = 1

'        Microsoft Jet OLEDB:Connection Control property values
Global Const JET_CONNCONTROL_PASSIVESHUTDOWN = 1
Global Const JET_CONNCONTROL_NORMAL = 2

' Microsoft Jet OLEDB:Transaction Commit Mode property values
Global Const JET_TCM_ASYNCFLUSH = 0
Global Const JET_TCM_SYNCFLUSH = 1
 
' Security GUIDS for Access Objects
Global Const JET_SECURITY_FORMS = _
    "{c49c842e-9dcb-11d1-9f0a-00c04fc2c2e0}"
Global Const JET_SECURITY_REPORTS = _
    "{c49c8430-9dcb-11d1-9f0a-00c04fc2c2e0}"
Global Const JET_SECURITY_MACROS = _
    "{c49c842f-9dcb-11d1-9f0a-00c04fc2c2e0}"
Global Const JET_SECURITY_MODULES = _
    "{c49c8432-9dcb-11d1-9f0a-00c04fc2c2e0}"

' Jet OLE DB Provider Defined Schema Rowsets
Global Const JET_SCHEMA_REPLPARTIALFILTERLIST = _
    "{e2082df0-54ac-11d1-bdbb-00c04fb92675}"
Global Const JET_SCHEMA_REPLCONFLICTTAGBLES = _
    "{e2082df2-54ac-11d1-bdbb-00c04fb92675}"
Global Const JET_SCHEMA_USERROSTER = _
    "{947bb102-5d43-11d1-bdbf-00c04fb92675}"
Global Const JET_SCHEMA_ISAMSTATS = _
    "{8703b612-5d43-11d1-bdbf-00c04fb92675}"