ADOX, COM interface constants for VB.Net / VBScript

ADOX - interface constants

     This page contains simple VBA include for the ADOX COM library.

library parameters

File NameWINDOWS\system32\dllcache\msadox.dll
Guid{00000600-0000-0010-8000-00AA006D2EA4}
Enums10

ColumnAttributesEnum

enum, 2 members.
Public Enum ColumnAttributesEnum
  adColFixed = 1  '&H1
  adColNullable = 2  '&H2
End Enum

SortOrderEnum

enum, 2 members.
Public Enum SortOrderEnum
  adSortAscending = 1  '&H1
  adSortDescending = 2  '&H2
End Enum

DataTypeEnum

enum, 39 members.
Public Enum DataTypeEnum
  adEmpty = 0  '&H0
  adTinyInt = 16  '&H10
  adSmallInt = 2  '&H2
  adInteger = 3  '&H3
  adBigInt = 20  '&H14
  adUnsignedTinyInt = 17  '&H11
  adUnsignedSmallInt = 18  '&H12
  adUnsignedInt = 19  '&H13
  adUnsignedBigInt = 21  '&H15
  adSingle = 4  '&H4
  adDouble = 5  '&H5
  adCurrency = 6  '&H6
  adDecimal = 14  '&HE
  adNumeric = 131  '&H83
  adBoolean = 11  '&HB
  adError = 10  '&HA
  adUserDefined = 132  '&H84
  adVariant = 12  '&HC
  adIDispatch = 9  '&H9
  adIUnknown = 13  '&HD
  adGUID = 72  '&H48
  adDate = 7  '&H7
  adDBDate = 133  '&H85
  adDBTime = 134  '&H86
  adDBTimeStamp = 135  '&H87
  adBSTR = 8  '&H8
  adChar = 129  '&H81
  adVarChar = 200  '&HC8
  adLongVarChar = 201  '&HC9
  adWChar = 130  '&H82
  adVarWChar = 202  '&HCA
  adLongVarWChar = 203  '&HCB
  adBinary = 128  '&H80
  adVarBinary = 204  '&HCC
  adLongVarBinary = 205  '&HCD
  adChapter = 136  '&H88
  adFileTime = 64  '&H40
  adPropVariant = 138  '&H8A
  adVarNumeric = 139  '&H8B
End Enum

AllowNullsEnum

enum, 4 members.
Public Enum AllowNullsEnum
  adIndexNullsAllow = 0  '&H0
  adIndexNullsDisallow = 1  '&H1
  adIndexNullsIgnore = 2  '&H2
  adIndexNullsIgnoreAny = 4  '&H4
End Enum

RuleEnum

enum, 4 members.
Public Enum RuleEnum
  adRINone = 0  '&H0
  adRICascade = 1  '&H1
  adRISetNull = 2  '&H2
  adRISetDefault = 3  '&H3
End Enum

KeyTypeEnum

enum, 3 members.
Public Enum KeyTypeEnum
  adKeyPrimary = 1  '&H1
  adKeyForeign = 2  '&H2
  adKeyUnique = 3  '&H3
End Enum

ObjectTypeEnum

enum, 6 members.
Public Enum ObjectTypeEnum
  adPermObjProviderSpecific = -1  '&HFFFFFFFF
  adPermObjTable = 1  '&H1
  adPermObjColumn = 2  '&H2
  adPermObjDatabase = 3  '&H3
  adPermObjProcedure = 4  '&H4
  adPermObjView = 5  '&H5
End Enum

RightsEnum

enum, 18 members.
Public Enum RightsEnum
  adRightNone = 0  '&H0
  adRightDrop = 256  '&H100
  adRightExclusive = 512  '&H200
  adRightReadDesign = 1024  '&H400
  adRightWriteDesign = 2048  '&H800
  adRightWithGrant = 4096  '&H1000
  adRightReference = 8192  '&H2000
  adRightCreate = 16384  '&H4000
  adRightInsert = 32768  '&H8000
  adRightDelete = 65536  '&H10000
  adRightReadPermissions = 131072  '&H20000
  adRightWritePermissions = 262144  '&H40000
  adRightWriteOwner = 524288  '&H80000
  adRightMaximumAllowed = 33554432  '&H2000000
  adRightFull = 268435456  '&H10000000
  adRightExecute = 536870912  '&H20000000
  adRightUpdate = 1073741824  '&H40000000
  adRightRead = -2147483648  '&H80000000
End Enum

ActionEnum

enum, 4 members.
Public Enum ActionEnum
  adAccessGrant = 1  '&H1
  adAccessSet = 2  '&H2
  adAccessDeny = 3  '&H3
  adAccessRevoke = 4  '&H4
End Enum

InheritTypeEnum

enum, 5 members.
Public Enum InheritTypeEnum
  adInheritNone = 0  '&H0
  adInheritObjects = 1  '&H1
  adInheritContainers = 2  '&H2
  adInheritBoth = 3  '&H3
  adInheritNoPropogate = 4  '&H4
End Enum
WUtils.com