ACC95: Constants in the Microsoft DAO 3.0 Object Library

Last reviewed: August 28, 1997
Article ID: Q140213

The information in this article applies to:

Microsoft Access version 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."

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

================================================================================

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: August 28, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.