ACC95: Constants in the Microsoft DAO 3.0 Object LibraryLast reviewed: August 28, 1997Article ID: Q140213 |
The information in this article applies to:
SUMMARYThis article lists the constant variables that are in the Microsoft Access for Windows 95 version 7.0 object library.
MORE INFORMATIONA 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"
REFERENCESFor more information about constants, search the Help Index for "constants." Keywords : kbprg MdlDao MdlLib Version : 7.0 Platform : WINDOWS Hardware : x86 Issue type : kbinfo |
================================================================================
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |