ACC95: Constants in the Microsoft DAO 3.0 Object Library

ID: Q140213


The information in this article applies to:
  • Microsoft Access 7.0


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" 


REFERENCES

For more information about constants, search the Help Index for constants.

Additional query words:

Keywords : kbprg MdlDao MdlLib
Version : WINDOWS:7.0
Platform : WINDOWS
Issue type : kbinfo


Last Reviewed: November 11, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.