MDAC 2.5 SDK - Technical Articles
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}"