Microsoft KB Archive/140213

= ACC95: Constants in the Microsoft DAO 3.0 Object Library =

Article ID: 140213

Article Last Modified on 10/11/2006

-

APPLIES TO


 * Microsoft Access 95 Standard Edition

-



This article was previously published under Q140213



SUMMARY
This article lists the constant variables that are in the Microsoft Access for Windows 95 version 7.0 object library.



MORE INFORMATION
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"

