DAO, COM interface constants for VB.Net / VBScript
DAO - interface constants
This page contains simple VBA include for the DAO COM library.
library parameters| File Name | WINDOWS\ServicePackFiles\i386\dao360.dll |
|---|
| Guid | {00025E01-0000-0000-C000-000000000046} |
|---|
| Enums | 27 |
|---|
RecordsetTypeEnumenum, 5 members.Public Enum RecordsetTypeEnum
dbOpenTable = 1
dbOpenDynaset = 2
dbOpenSnapshot = 4
dbOpenForwardOnly = 8
dbOpenDynamic = 16
End Enum
EditModeEnumenum, 3 members.Public Enum EditModeEnum
dbEditNone = 0
dbEditInProgress = 1
dbEditAdd = 2
End Enum
RecordsetOptionEnumenum, 12 members.Public Enum RecordsetOptionEnum
dbDenyWrite = 1
dbDenyRead = 2
dbReadOnly = 4
dbAppendOnly = 8
dbInconsistent = 16
dbConsistent = 32
dbSQLPassThrough = 64
dbFailOnError = 128
dbForwardOnly = 256
dbSeeChanges = 512
dbRunAsync = 1024
dbExecDirect = 2048
End Enum
LockTypeEnumenum, 4 members.Public Enum LockTypeEnum
dbPessimistic = 2
dbOptimistic = 3
dbOptimisticValue = 1
dbOptimisticBatch = 5
End Enum
UpdateCriteriaEnumenum, 6 members.Public Enum UpdateCriteriaEnum
dbCriteriaKey = 1
dbCriteriaModValues = 2
dbCriteriaAllCols = 4
dbCriteriaTimestamp = 8
dbCriteriaDeleteInsert = 16
dbCriteriaUpdate = 32
End Enum
FieldAttributeEnumenum, 7 members.Public Enum FieldAttributeEnum
dbFixedField = 1
dbVariableField = 2
dbAutoIncrField = 16
dbUpdatableField = 32
dbSystemField = 8192
dbHyperlinkField = 32768
dbDescending = 1
End Enum
DataTypeEnumenum, 21 members.Public Enum DataTypeEnum
dbBoolean = 1
dbByte = 2
dbInteger = 3
dbLong = 4
dbCurrency = 5
dbSingle = 6
dbDouble = 7
dbDate = 8
dbBinary = 9
dbText = 10
dbLongBinary = 11
dbMemo = 12
dbGUID = 15
dbBigInt = 16
dbVarBinary = 17
dbChar = 18
dbNumeric = 19
dbDecimal = 20
dbFloat = 21
dbTime = 22
dbTimeStamp = 23
End Enum
RelationAttributeEnumenum, 7 members.Public Enum RelationAttributeEnum
dbRelationUnique = 1
dbRelationDontEnforce = 2
dbRelationInherited = 4
dbRelationUpdateCascade = 256
dbRelationDeleteCascade = 4096
dbRelationLeft = 16777216
dbRelationRight = 33554432
End Enum
TableDefAttributeEnumenum, 6 members.Public Enum TableDefAttributeEnum
dbAttachExclusive = 65536
dbAttachSavePWD = 131072
dbSystemObject = -2147483646
dbAttachedTable = 1073741824
dbAttachedODBC = 536870912
dbHiddenObject = 1
End Enum
QueryDefTypeEnumenum, 13 members.Public Enum QueryDefTypeEnum
dbQSelect = 0
dbQProcedure = 224
dbQAction = 240
dbQCrosstab = 16
dbQDelete = 32
dbQUpdate = 48
dbQAppend = 64
dbQMakeTable = 80
dbQDDL = 96
dbQSQLPassThrough = 112
dbQSetOperation = 128
dbQSPTBulk = 144
dbQCompound = 160
End Enum
QueryDefStateEnumenum, 2 members.Public Enum QueryDefStateEnum
dbQPrepare = 1
dbQUnprepare = 2
End Enum
DatabaseTypeEnumenum, 7 members.Public Enum DatabaseTypeEnum
dbVersion10 = 1
dbEncrypt = 2
dbDecrypt = 4
dbVersion11 = 8
dbVersion20 = 16
dbVersion30 = 32
dbVersion40 = 64
End Enum
CollatingOrderEnumenum, 25 members.Public Enum CollatingOrderEnum
dbSortNeutral = 1024
dbSortArabic = 1025
dbSortCyrillic = 1049
dbSortCzech = 1029
dbSortDutch = 1043
dbSortGeneral = 1033
dbSortGreek = 1032
dbSortHebrew = 1037
dbSortHungarian = 1038
dbSortIcelandic = 1039
dbSortNorwdan = 1030
dbSortPDXIntl = 1033
dbSortPDXNor = 1030
dbSortPDXSwe = 1053
dbSortPolish = 1045
dbSortSpanish = 1034
dbSortSwedFin = 1053
dbSortTurkish = 1055
dbSortJapanese = 1041
dbSortChineseSimplified = 2052
dbSortChineseTraditional = 1028
dbSortKorean = 1042
dbSortThai = 1054
dbSortSlovenian = 1060
dbSortUndefined = -1
End Enum
IdleEnumenum, 2 members.Public Enum IdleEnum
dbFreeLocks = 1
dbRefreshCache = 8
End Enum
PermissionEnumenum, 17 members.Public Enum PermissionEnum
dbSecNoAccess = 0
dbSecFullAccess = 1048575
dbSecDelete = 65536
dbSecReadSec = 131072
dbSecWriteSec = 262144
dbSecWriteOwner = 524288
dbSecDBCreate = 1
dbSecDBOpen = 2
dbSecDBExclusive = 4
dbSecDBAdmin = 8
dbSecCreate = 1
dbSecReadDef = 4
dbSecWriteDef = 65548
dbSecRetrieveData = 20
dbSecInsertData = 32
dbSecReplaceData = 64
dbSecDeleteData = 128
End Enum
SynchronizeTypeEnumenum, 4 members.Public Enum SynchronizeTypeEnum
dbRepExportChanges = 1
dbRepImportChanges = 2
dbRepImpExpChanges = 4
dbRepSyncInternet = 16
End Enum
ReplicaTypeEnumenum, 2 members.Public Enum ReplicaTypeEnum
dbRepMakeReadOnly = 2
dbRepMakePartial = 1
End Enum
WorkspaceTypeEnumenum, 2 members.Public Enum WorkspaceTypeEnum
dbUseODBC = 1
dbUseJet = 2
End Enum
CursorDriverEnumenum, 5 members.Public Enum CursorDriverEnum
dbUseDefaultCursor = -1
dbUseODBCCursor = 1
dbUseServerCursor = 2
dbUseClientBatchCursor = 3
dbUseNoCursor = 4
End Enum
DriverPromptEnumenum, 4 members.Public Enum DriverPromptEnum
dbDriverPrompt = 2
dbDriverNoPrompt = 1
dbDriverComplete = 0
dbDriverCompleteRequired = 3
End Enum
SetOptionEnumenum, 11 members.Public Enum SetOptionEnum
dbPageTimeout = 6
dbLockRetry = 57
dbMaxBufferSize = 8
dbUserCommitSync = 58
dbImplicitCommitSync = 59
dbExclusiveAsyncDelay = 60
dbSharedAsyncDelay = 61
dbMaxLocksPerFile = 62
dbLockDelay = 63
dbRecycleLVs = 65
dbFlushTransactionTimeout = 66
End Enum
ParameterDirectionEnumenum, 4 members.Public Enum ParameterDirectionEnum
dbParamInput = 1
dbParamOutput = 2
dbParamInputOutput = 3
dbParamReturnValue = 4
End Enum
UpdateTypeEnumenum, 3 members.Public Enum UpdateTypeEnum
dbUpdateBatch = 4
dbUpdateRegular = 1
dbUpdateCurrentRecord = 2
End Enum
RecordStatusEnumenum, 5 members.Public Enum RecordStatusEnum
dbRecordUnmodified = 0
dbRecordModified = 1
dbRecordNew = 2
dbRecordDeleted = 3
dbRecordDBDeleted = 4
End Enum
CommitTransOptionsEnumenum, 1 members.Public Enum CommitTransOptionsEnum
dbForceOSFlush = 1
End Enum
_DAOSuppHelpenum, 5 members.Public Enum DAOSuppHelp
LogMessages = 0
KeepLocal = 0
Replicable = 0
ReplicableBool = 0
V1xNullBehavior = 0
End Enum
LanguageConstantsmodule, 21 members.Public Enum LanguageConstants
dbLangArabic = ";LANGID=0x0401;CP=1256;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=0x0406;CP=1252;COUNTRY=0"
dbLangPolish = ";LANGID=0x0415;CP=1250;COUNTRY=0"
dbLangCyrillic = ";LANGID=0x0419;CP=1251;COUNTRY=0"
dbLangSpanish = ";LANGID=0x040A;CP=1252;COUNTRY=0"
dbLangSwedFin = ";LANGID=0x041D;CP=1252;COUNTRY=0"
dbLangTurkish = ";LANGID=0x041F;CP=1254;COUNTRY=0"
dbLangJapanese = ";LANGID=0x0411;CP=932;COUNTRY=0"
dbLangChineseSimplified = ";LANGID=0x0804;CP=936;COUNTRY=0"
dbLangChineseTraditional = ";LANGID=0x0404;CP=950;COUNTRY=0"
dbLangKorean = ";LANGID=0x0412;CP=949;COUNTRY=0"
dbLangThai = ";LANGID=0x041E;CP=874;COUNTRY=0"
dbLangSlovenian = ";LANGID=0x0424;CP=1250;COUNTRY=0"
End Enum
|