ADO/DAO Constants
Keywords: ADO/DAO Constants reference
The following reference for constant values may be helpful to some.
Use for DAO (Data Access Objects) or ADO (Active Data Objects).
;ado value constant refers to
adBigInt = 20 ;Indicates an eight-byte signed integer (DBTYPE_I8).
adBinary = 128 ;Indicates a binary value (DBTYPE_BYTES).
adBoolean = 11 ;Indicates a boolean value (DBTYPE_BOOL).
adBSTR = 8 ;Indicates a null-terminated character string (Unicode) (DBTYPE_BSTR).
adChapter = 136 ;Indicates a four-byte chapter value that identifies rows in a child rowset (DBTYPE_HCHAPTER).
adChar = 129 ;Indicates a string value (DBTYPE_STR).
adCurrency = 6 ;Indicates a currency value (DBTYPE_CY). Currency is a fixed-point number with four digits to the right of the decimal point. It is stored in an eight-byte signed integer scaled by 10,000.
adDate = 7 ;Indicates a date value (DBTYPE_DATE). A date is stored as a double, the whole part of which is the number of days since December 30, 1899, and the fractional part of which is the fraction of a day.
adDBDate = 133 ;Indicates a date value (yyyymmdd) (DBTYPE_DBDATE).
adDBTime = 134 ;Indicates a time value (hhmmss) (DBTYPE_DBTIME).
adDBTimeStamp = 135 ;Indicates a date/time stamp (yyyymmddhhmmss plus a fraction in billionths) (DBTYPE_DBTIMESTAMP).
adDecimal = 14 ;Indicates an exact numeric value with a fixed precision and scale (DBTYPE_DECIMAL).
adDouble = 5 ;Indicates a double-precision floating-point value (DBTYPE_R8).
adEmpty = 0 ;Specifies no value (DBTYPE_EMPTY).
adError = 10 ;Indicates a 32-bit error code (DBTYPE_ERROR).
adFileTime = 64 ;Indicates a 64-bit value representing the number of 100-nanosecond intervals since January 1, 1601 (DBTYPE_FILETIME).
adGUID = 72 ;Indicates a globally unique identifier (GUID) (DBTYPE_GUID).
adIDispatch = 9 ;Indicates a pointer to an IDispatch interface on a COM object (DBTYPE_IDISPATCH).
;This data type is currently not supported by ADO. Usage may cause unpredictable results.
adInteger = 3 ;Indicates a four-byte signed integer (DBTYPE_I4).
adIUnknown = 13 ;Indicates a pointer to an IUnknown interface on a COM object (DBTYPE_IUNKNOWN).
;This data type is currently not supported by ADO. Usage may cause unpredictable results.
adLongVarBinary = 205 ;Indicates a long binary value (Parameter object only).
adLongVarChar = 201 ;Indicates a long string value (Parameter object only).
adLongVarWChar = 203 ;Indicates a long null-terminated Unicode string value (Parameter object only).
adNumeric = 131 ;Indicates an exact numeric value with a fixed precision and scale (DBTYPE_NUMERIC).
adPropVariant = 138 ;Indicates an Automation PROPVARIANT (DBTYPE_PROP_VARIANT).
adSingle = 4 ;Indicates a single-precision floating-point value (DBTYPE_R4).
adSmallInt = 2 ;Indicates a two-byte signed integer (DBTYPE_I2).
adTinyInt = 16 ;Indicates a one-byte signed integer (DBTYPE_I1).
adUnsignedBigInt = 21 ;Indicates an eight-byte unsigned integer (DBTYPE_UI8).
adUnsignedInt = 19 ;Indicates a four-byte unsigned integer (DBTYPE_UI4).
adUnsignedSmallInt = 18 ;Indicates a two-byte unsigned integer (DBTYPE_UI2).
adUnsignedTinyInt = 17 ;Indicates a one-byte unsigned integer (DBTYPE_UI1).
adUserDefined = 132 ;Indicates a user-defined variable (DBTYPE_UDT).
adVarBinary = 204 ;Indicates a binary value (Parameter object only).
adVarChar = 200 ;Indicates a string value (Parameter object only).
adVariant = 12 ;Indicates an Automation Variant (DBTYPE_VARIANT).
;This data type is currently not supported by ADO. Usage may cause unpredictable results.
adVarNumeric = 139 ;Indicates a numeric value (Parameter object only).
adVarWChar = 202 ;Indicates a null-terminated Unicode character string (Parameter object only).
adWChar = 130 ;Indicates a null-terminated Unicode character string (DBTYPE_WSTR).
;other values constant ;DAO constants for how RecordSet is Open
dbUseJet = 2
dbUseODBC = 1
dbOpenDynamic = 16 (&H10)
dbOpenDynaset = 2
dbOpenForwardOnly = 8
dbOpenSnapshot = 4
dbOpenTable = 1
dbAppendOnly = 8
dbSQLPassThrough = 64 (&H40)
dbSeeChanges = 512 (&H200)
dbDenyRead = 2
dbDenyWrite = 1
dbForwardOnly = 256 (&H100)
dbReadOnly = 4
dbRunAsync = 1024 (&H400)
dbExecDirect = 2048 (&H800)
dbConsistent = 32 (&H20)
dbInconsistent = 16 (&H10)
;other values constant ;ACCESS constants for TransferDatabase()
acLink = 2
acImport = 0
acExport = 1
;other values constant ;ACCESS constants for Object Types
acTable = 0
acReport = 3
acModule = 5
acMacro = 4
acForm = 2
Article ID: W14568
Filename: ADO - DAO Constants.txt