ID: Q140213
The information in this article applies to:
This article lists the constant variables that are in the Microsoft Access for Windows 95 version 7.0 object library.
A listing of all the available constants in the Microsoft Access 7.0 object library is available by using the Object Browser. To use Object Browser, open a module in Design view, press F2, and select "DAO 3.0 Object Library" in the Libraries/Database box. Then, choose "constants" from the list box in the lower left corner of the dialog box.
MS Access 7.0 Value MS Access 2.0 Value
------------- ----- ------------- -----
dbSystemObject -2147483646 DB_SYSTEMOBJECT &H80000002
dbRelationRight 33554432 DB_RELATIONRIGHT &H2000000
dbRelationUnique 1 DB_RELATIONUNIQUE &H1&
dbRelationUpdateCascade 256 DB_RELATIONUPDATECASCADE &H100&
dbSecCreate 1 DB_SEC_CREATE &H1&
dbSecDBCreate 1 DB_SEC_DBCREATE &H1&
dbSecDBExclusive 4 DB_SEC_DBEXCLUSIVE &H4&
dbSecDBOpen 2 DB_SEC_DBOPEN &H2&
dbSecDelete 65536 DB_SEC_DELETE &H10000
dbSecDeleteData 128 DB_SEC_DELETEDATA &H80&
dbSecFullAccess 1048575 DB_SEC_FULLACCESS &HFFFFF
dbSecInsertData 32 DB_SEC_INSERTDATA &H20&
dbSecNoAccess 0 DB_SEC_NOACCESS &H0&
dbSecReadDef 4 DB_SEC_READDEF &H4&
dbSecReadSec 131072 DB_SEC_READSEC &H20000
dbSecReplaceData 64 DB_SEC_REPLACEDATA &H40&
dbSecRetrieveData 20 DB_SEC_RETRIEVEDATA &H10&
dbSecWriteDef 65548 DB_SEC_WRITEDEF &H8&
dbSecWriteOwner 524288 DB_SEC_WRITEOWNER &H80000
dbSecWriteSec 262144 DB_SEC_WRITESEC &H40000
dbSingle 6 DB_SINGLE 6
dbSortArabic 1025 DB_SORTARABIC 267
dbSortCyrillic 1049 DB_SORTCYRILLIC 263
dbSortCzech 1029 DB_SORTCZECH 264
dbSortDutch 1043 DB_SORTDUTCH 259
dbSortGeneral 1033 DB_SORTGENERAL 269
dbSortHebrew 1037 DB_SORTHEBREW 268
dbSortHungarian 1038 DB_SORTHUNGARIAN 265
dbSortIcelandic 1039 DB_SORTICELANDIC 262
dbSortNorwdan 1030 DB_SORTNORWDAN 261
dbSortPDXIntl 1033 DB_SORTPDXINTL 4096
dbSortPDXNor 1030 DB_SORTPDXNOR 4098
dbSortPDXSwe 1053 DB_SORTPDXSWE 4097
dbSortPolish 1045 DB_SORTPOLISH 266
dbSortSpanish 1034 DB_SORTSPANISH 258
dbSortSwedFin 1053 DB_SORTSWEDFIN 260
dbSortTurkish 1055 DB_SORTTURKISH 270
dbSortUndefined -1 DB_SORTUNDEFINED -1
dbSQLPassThrough 64 DB_SQLPASSTHROUGH &H40
dbText 10 DB_TEXT 10
dbUpdatableField 32 DB_UPDATABLEFIELD &H20
dbVariableField 2 DB_VARIABLEFIELD &H2
dbVersion10 1 DB_VERSION10 1
dbVersion11 8 DB_VERSION11 8
dbVersion20 16 DB_VERSION20 16
dbGUID 15
dbVersion30 32
dbSystemField 8192
dbEditAdd 2
dbEditInProgress 1
dbEditNone 0
dbRepExportChanges 1
dbRepImpExpChanges 4
dbRepImportChanges 2
dbRepMakeReadOnly 2
dbSecDBAdmin 8
dbSeeChanges 512
dbSortJapanese 1041
dbSortNeutral 1024
MS Access 7.0 Value MS Access 2.0 Value
------------- ----- ------------- -----
DB_BINARY 9
DB_IGNORENULL 8
DB_NONULLS 3
DB_OLE 11
DB_OPTIONINIPATH 1
DB_PRIMARY 2
DB_PROHIBITNULL 4
DB_QUERYDEF 5
DB_TABLE 1
DB_UNIQUE 1
dbAppendOnly 8 DB_APPENDONLY &H8
dbAttachedODBC 536870912 DB_ATTACHEDODBC &H20000000
dbAttachedTable 1073741824 DB_ATTACHEDTABLE &H40000000
dbAttachExclusive 65536 DB_ATTACHEXCLUSIVE &H10000
dbAttachSavePWD 131072 DB_ATTACHSAVEPWD &H20000
dbAutoIncrField 16 DB_AUTOINCRFIELD &H10
dbBoolean 1 DB_BOOLEAN 1
dbByte 2 DB_BYTE 2
dbConsistent 32 DB_CONSISTENT &H20
dbCurrency 5 DB_CURRENCY 5
dbDate 8 DB_DATE 8
dbDecrypt 4 DB_DECRYPT 4
dbDenyRead 2 DB_DENYREAD &H2
dbDenyWrite 1 DB_DENYWRITE &H1
dbDescending 1 DB_DESCENDING &H1
dbDouble 7 DB_DOUBLE 7
dbEncrypt 2 DB_ENCRYPT 2
dbFailOnError 128 DB_FAILONERROR &H80
dbFixedField 1 DB_FIXEDFIELD &H1
dbForwardOnly 256 DB_FORWARDONLY &H100
dbFreeLocks 1 DB_FREELOCKS 1
dbHiddenObject 1 DB_HIDDENOBJECT &H1&
dbInconsistent 16 DB_INCONSISTENT &H10
dbInteger 3 DB_INTEGER 3
dbLong 4 DB_LONG 4
dbLongBinary 11 DB_LONGBINARY 11
dbMemo 12 DB_MEMO 12
dbOpenDynaset 2 DB_OPEN_DYNASET 2
dbOpenSnapshot 4 DB_OPEN_SNAPSHOT 4
dbOpenTable 1 DB_OPEN_TABLE 1
dbQAction 240 DB_QACTION &HF0
dbQAppend 64 DB_QAPPEND &H40
dbQCrosstab 16 DB_QCROSSTAB &H10
dbQDDL 96 DB_QDDL &H60
dbQDelete 32 DB_QDELETE &H20
dbQMakeTable 80 DB_QMAKETABLE &H50
dbQSelect 0 DB_QSELECT &H0
dbQSetOperation 128 DB_QSETOPERATION &H80
dbQSPTBulk 144 DB_QSPTBULK &H90
dbQSQLPassThrough 112 DB_QSQLPASSTHROUGH &H70
dbQUpdate 48 DB_QUPDATE &H30
dbReadOnly 4 DB_READONLY &H4
dbRelationDeleteCascade 4096 DB_RELATIONDELETECASCADE &H1000&
dbRelationDontEnforce 2 DB_RELATIONDONTENFORCE &H2&
dbRelationInherited 4 DB_RELATIONINHERITED &H4&
dbRelationLeft 16777216 DB_RELATIONLEFT &H1000000
dbSortChineseSimplified 2052
dbSortChineseTraditional 1028
dbSortKorean 1036
dbSortThai 4126
MS Access 7.0 Value
------------- -----
dbLangJapanese ";LANGID=0x0411;CP=932;COUNTRY=0"
dbLangArabic ";LANGID=0x0401;CP=1256;COUNTRY=0"
dbLangCyrillic ";LANGID=0x0419;CP=1251;COUNTRY=0"
dbLangCzech ";LANGID=0x0405;CP=1250;COUNTRY=0"
dbLangDutch ";LANGID=0x0413;CP=1252;COUNTRY=0"
dbLangGeneral ";LANGID=0x0409;CP=1252;COUNTRY=0"
dbLangGreek ";LANGID=0x0408;CP=1253;COUNTRY=0"
dbLangHebrew ";LANGID=0x040D;CP=1255;COUNTRY=0"
dbLangHungarian ";LANGID=0x040E;CP=1250;COUNTRY=0"
dbLangIcelandic ";LANGID=0x040F;CP=1252;COUNTRY=0"
dbLangNordic ";LANGID=0x041D;CP=1252;COUNTRY=0"
dbLangNorwdan ";LANGID=0x0414;CP=1252;COUNTRY=0"
dbLangPolish ";LANGID=0x0415;CP=1250;COUNTRY=0"
dbLangSpanish ";LANGID=0x040A;CP=1252;COUNTRY=0"
dbLangSwedfin ";LANGID=0x040B;CP=1252;COUNTRY=0"
dbLangTurkish ";LANGID=0x041F;CP=1254;COUNTRY=0"
dbLangChineseSimplified ";LANGID=0x0804;CP=936;COUNTRY=0"
dbLangChineseTraditional ";LANGID=0x0404;CP=950;COUNTRY=0"
dbLangKorean ";LANGID=0x040C;CP=494;COUNTRY=0"
dbLangThai ";LANGID=0x101E;CP=874;COUNTRY=0"
MS Access 2.0 Value
------------- -----
DB_LANG_ARABIC ";LANGID=0x0401;CP=1256;COUNTRY=0"
DB_LANG_CYRILLIC ";LANGID=0x0419;CP=1251;COUNTRY=0"
DB_LANG_CZECH ";LANGID=0x0405;CP=1250;COUNTRY=0"
DB_LANG_DUTCH ";LANGID=0x0413;CP=1252;COUNTRY=0"
DB_LANG_GENERAL ";LANGID=0x0409;CP=1252;COUNTRY=0"
DB_LANG_GREEK ";LANGID=0x0408;CP=1253;COUNTRY=0"
DB_LANG_HEBREW ";LANGID=0x040D;CP=1255;COUNTRY=0"
DB_LANG_HUNGARIAN ";LANGID=0x040E;CP=1250;COUNTRY=0"
DB_LANG_ICELANDIC ";LANGID=0x040F;CP=1252;COUNTRY=0"
DB_LANG_NORDIC ";LANGID=0x041D;CP=1252;COUNTRY=0"
DB_LANG_NORWDAN ";LANGID=0x0414;CP=1252;COUNTRY=0"
DB_LANG_POLISH ";LANGID=0x0415;CP=1250;COUNTRY=0"
DB_LANG_SPANISH ";LANGID=0x040A;CP=1252;COUNTRY=0"
DB_LANG_SWEDFIN ";LANGID=0x040B;CP=1252;COUNTRY=0"
DB_LANG_TURKISH ";LANGID=0x041F;CP=1254;COUNTRY=0"
For more information about constants, search the Help Index for "constants."
Keywords : kbprg MdlDao MdlLib
Version : 7.0
Platform : WINDOWS
Hardware : x86
Issue type : kbinfoLast Reviewed: August 29, 1997