C:\Program Files\Common Files\SYSTEM\ADO\msado15.dll

_ADO Description
Property Properties As Properties

_Collection Description
Property Count As Long
Sub Refresh

_DynaCollection Description
Property Count As Long
Sub Append(ByVal Object As Object)
Sub Delete(ByVal Index)
Sub Refresh

ADCPROP_ASYNCTHREADPRIORITY_ENUM Description
Const adPriorityAboveNormal = 4
Const adPriorityBelowNormal = 2
Const adPriorityHighest = 5
Const adPriorityLowest = 1
Const adPriorityNormal = 3

ADCPROP_AUTORECALC_ENUM Description
Const adRecalcAlways = 1
Const adRecalcUpFront = 0

ADCPROP_UPDATECRITERIA_ENUM Description
Const adCriteriaAllCols = 1
Const adCriteriaKey = 0
Const adCriteriaTimeStamp = 3
Const adCriteriaUpdCols = 2

ADCPROP_UPDATERESYNC_ENUM Description
Const adResyncAll = 15
Const adResyncAutoIncrement = 1
Const adResyncConflicts = 2
Const adResyncInserts = 8
Const adResyncNone = 0
Const adResyncUpdates = 4

AffectEnum Description
Const adAffectAll = 3 (undocumented)
Const adAffectAllChapters = 4
Const adAffectCurrent = 1
Const adAffectGroup = 2

BookmarkEnum Description
Const adBookmarkCurrent = 0
Const adBookmarkFirst = 1
Const adBookmarkLast = 2

Command Description
Property ActiveConnection As _Connection
Property CommandText As String
Property CommandTimeout As Long
Property CommandType As CommandTypeEnum
Property Name As String
Property Parameters As Parameters
Property Prepared As Boolean
Property Properties As Properties
Property State As Long
Sub Cancel
Function CreateParameter([ByVal Name As String], [ByVal Type As DataTypeEnumadEmpty], [ByVal Direction As ParameterDirectionEnumadParamInput], [ByVal Size As Long], [ByVal Value]) As _Parameter
Function Execute(RecordsAffected, Parameters, [ByVal Options As Long-1]) As _Recordset

Command15 Description
Property ActiveConnection As _Connection
Property CommandText As String
Property CommandTimeout As Long
Property CommandType As CommandTypeEnum
Property Name As String
Property Parameters As Parameters
Property Prepared As Boolean
Property Properties As Properties
Function CreateParameter([ByVal Name As String], [ByVal Type As DataTypeEnumadEmpty], [ByVal Direction As ParameterDirectionEnumadParamInput], [ByVal Size As Long], [ByVal Value]) As _Parameter
Function Execute(RecordsAffected, Parameters, [ByVal Options As Long-1]) As _Recordset

CommandTypeEnum Description
Const adCmdFile = 256 (&H100)
Const adCmdStoredProc = 4
Const adCmdTable = 2
Const adCmdTableDirect = 512 (&H200)
Const adCmdText = 1
Const adCmdUnknown = 8
Const adCmdUnspecified = -1 (&HFFFFFFFF) (undocumented)

CompareEnum Description
Const adCompareEqual = 1
Const adCompareGreaterThan = 2
Const adCompareLessThan = 0
Const adCompareNotComparable = 4
Const adCompareNotEqual = 3

Connection Description
Property Attributes As Long
Property CommandTimeout As Long
Property ConnectionString As String
Property ConnectionTimeout As Long
Property CursorLocation As CursorLocationEnum
Property DefaultDatabase As String
Property Errors As Errors
Property IsolationLevel As IsolationLevelEnum
Property Mode As ConnectModeEnum
Property Properties As Properties
Property Provider As String
Property State As Long
Property Version As String
Sub Cancel
Sub Close
Sub CommitTrans
Sub Open([ByVal ConnectionString As String], [ByVal UserID As String], [ByVal Password As String], [ByVal Options As Long-1])
Sub RollbackTrans
Function BeginTrans As Long
Function Execute(ByVal CommandText As String, RecordsAffected, [ByVal Options As Long-1]) As _Recordset
Function OpenSchema(ByVal Schema As SchemaEnum, [ByVal Restrictions], [ByVal SchemaID]) As _Recordset
Sub BeginTransComplete(ByVal TransactionLevel As Long, ByVal pError As Error, adStatus As EventStatusEnum, ByVal pConnection As _Connection)
Sub CommitTransComplete(ByVal pError As Error, adStatus As EventStatusEnum, ByVal pConnection As _Connection)
Sub ConnectComplete(ByVal pError As Error, adStatus As EventStatusEnum, ByVal pConnection As _Connection)
Sub Disconnect(adStatus As EventStatusEnum, ByVal pConnection As _Connection)
Sub ExecuteComplete(ByVal RecordsAffected As Long, ByVal pError As Error, adStatus As EventStatusEnum, ByVal pCommand As _Command, ByVal pRecordset As _Recordset, ByVal pConnection As _Connection)
Sub InfoMessage(ByVal pError As Error, adStatus As EventStatusEnum, ByVal pConnection As _Connection)
Sub RollbackTransComplete(ByVal pError As Error, adStatus As EventStatusEnum, ByVal pConnection As _Connection)
Sub WillConnect(ConnectionString As String, UserID As String, Password As String, Options As Long, adStatus As EventStatusEnum, ByVal pConnection As _Connection)
Sub WillExecute(Source As String, CursorType As CursorTypeEnum, LockType As LockTypeEnum, Options As Long, adStatus As EventStatusEnum, ByVal pCommand As _Command, ByVal pRecordset As _Recordset, ByVal pConnection As _Connection)

Connection15 Description
Property Attributes As Long
Property CommandTimeout As Long
Property ConnectionString As String
Property ConnectionTimeout As Long
Property CursorLocation As CursorLocationEnum
Property DefaultDatabase As String
Property Errors As Errors
Property IsolationLevel As IsolationLevelEnum
Property Mode As ConnectModeEnum
Property Properties As Properties
Property Provider As String
Property State As Long
Property Version As String
Sub Close
Sub CommitTrans
Sub Open([ByVal ConnectionString As String], [ByVal UserID As String], [ByVal Password As String], [ByVal Options As Long-1])
Sub RollbackTrans
Function BeginTrans As Long
Function Execute(ByVal CommandText As String, RecordsAffected, [ByVal Options As Long-1]) As _Recordset
Function OpenSchema(ByVal Schema As SchemaEnum, [ByVal Restrictions], [ByVal SchemaID]) As _Recordset

ConnectionEventsVt Description
Sub BeginTransComplete(ByVal TransactionLevel As Long, ByVal pError As Error, adStatus As EventStatusEnum, ByVal pConnection As _Connection)
Sub CommitTransComplete(ByVal pError As Error, adStatus As EventStatusEnum, ByVal pConnection As _Connection)
Sub ConnectComplete(ByVal pError As Error, adStatus As EventStatusEnum, ByVal pConnection As _Connection)
Sub Disconnect(adStatus As EventStatusEnum, ByVal pConnection As _Connection)
Sub ExecuteComplete(ByVal RecordsAffected As Long, ByVal pError As Error, adStatus As EventStatusEnum, ByVal pCommand As _Command, ByVal pRecordset As _Recordset, ByVal pConnection As _Connection)
Sub InfoMessage(ByVal pError As Error, adStatus As EventStatusEnum, ByVal pConnection As _Connection)
Sub RollbackTransComplete(ByVal pError As Error, adStatus As EventStatusEnum, ByVal pConnection As _Connection)
Sub WillConnect(ConnectionString As String, UserID As String, Password As String, Options As Long, adStatus As EventStatusEnum, ByVal pConnection As _Connection)
Sub WillExecute(Source As String, CursorType As CursorTypeEnum, LockType As LockTypeEnum, Options As Long, adStatus As EventStatusEnum, ByVal pCommand As _Command, ByVal pRecordset As _Recordset, ByVal pConnection As _Connection)

ConnectModeEnum Description
Const adModeRead = 1
Const adModeReadWrite = 3
Const adModeRecursive = 4194304 (&H400000)
Const adModeShareDenyNone = 16 (&H10)
Const adModeShareDenyRead = 4
Const adModeShareDenyWrite = 8
Const adModeShareExclusive = 12
Const adModeUnknown = 0
Const adModeWrite = 2

ConnectOptionEnum Description
Const adAsyncConnect = 16 (&H10)
Const adConnectUnspecified = -1 (&HFFFFFFFF) (undocumented)

ConnectPromptEnum Description
Const adPromptAlways = 1
Const adPromptComplete = 2
Const adPromptCompleteRequired = 3
Const adPromptNever = 4

CopyRecordOptionsEnum Description
Const adCopyAllowEmulation = 4
Const adCopyNonRecursive = 2
Const adCopyOverWrite = 1
Const adCopyUnspecified = -1 (&HFFFFFFFF)

CursorLocationEnum Description
Const adUseClient = 3
Const adUseClientBatch = 3 (undocumented)
Const adUseNone = 1 (undocumented)
Const adUseServer = 2

CursorOptionEnum Description
Const adAddNew = 16778240 (&H1000400)
Const adApproxPosition = 16384 (&H4000)
Const adBookmark = 8192 (&H2000)
Const adDelete = 16779264 (&H1000800)
Const adFind = 524288 (&H80000)
Const adHoldRecords = 256 (&H100)
Const adIndex = 8388608 (&H800000)
Const adMovePrevious = 512 (&H200)
Const adNotify = 262144 (&H40000)
Const adResync = 131072 (&H20000)
Const adSeek = 4194304 (&H400000)
Const adUpdate = 16809984 (&H1008000)
Const adUpdateBatch = 65536 (&H10000)

CursorTypeEnum Description
Const adOpenDynamic = 2
Const adOpenForwardOnly = 0
Const adOpenKeyset = 1
Const adOpenStatic = 3
Const adOpenUnspecified = -1 (&HFFFFFFFF) (undocumented)

DataTypeEnum Description
Const adArray = 8192 (&H2000)
Const adBigInt = 20 (&H14)
Const adBinary = 128 (&H80)
Const adBoolean = 11
Const adBSTR = 8
Const adChapter = 136 (&H88)
Const adChar = 129 (&H81)
Const adCurrency = 6
Const adDate = 7
Const adDBDate = 133 (&H85)
Const adDBTime = 134 (&H86)
Const adDBTimeStamp = 135 (&H87)
Const adDecimal = 14
Const adDouble = 5
Const adEmpty = 0
Const adError = 10
Const adFileTime = 64 (&H40)
Const adGUID = 72 (&H48)
Const adIDispatch = 9
Const adInteger = 3
Const adIUnknown = 13
Const adLongVarBinary = 205 (&HCD)
Const adLongVarChar = 201 (&HC9)
Const adLongVarWChar = 203 (&HCB)
Const adNumeric = 131 (&H83)
Const adPropVariant = 138 (&H8A)
Const adSingle = 4
Const adSmallInt = 2
Const adTinyInt = 16 (&H10)
Const adUnsignedBigInt = 21 (&H15)
Const adUnsignedInt = 19 (&H13)
Const adUnsignedSmallInt = 18 (&H12)
Const adUnsignedTinyInt = 17 (&H11)
Const adUserDefined = 132 (&H84)
Const adVarBinary = 204 (&HCC)
Const adVarChar = 200 (&HC8)
Const adVariant = 12
Const adVarNumeric = 139 (&H8B)
Const adVarWChar = 202 (&HCA)
Const adWChar = 130 (&H82)

EditModeEnum Description
Const adEditAdd = 2
Const adEditDelete = 4
Const adEditInProgress = 1
Const adEditNone = 0

Error Description
Property Description As String
Property HelpContext As Long
Property HelpFile As String
Property NativeError As Long
Property Number As Long
Property Source As String
Property SQLState As String

Errors Description
Property Count As Long
Property Item(ByVal Index) As Error
Sub Clear
Sub Refresh

ErrorValueEnum Description
Const adErrBoundToCommand = 3707 (&HE7B)
Const adErrCannotComplete = 3732 (&HE94)
Const adErrCantChangeConnection = 3748 (&HEA4)
Const adErrCantChangeProvider = 3220 (&HC94)
Const adErrCantConvertvalue = 3724 (&HE8C)
Const adErrCantCreate = 3725 (&HE8D)
Const adErrCatalogNotSet = 3747 (&HEA3)
Const adErrColumnNotOnThisRow = 3726 (&HE8E)
Const adErrDataConversion = 3421 (&HD5D)
Const adErrDataOverflow = 3721 (&HE89)
Const adErrDelResOutOfScope = 3738 (&HE9A)
Const adErrDenyNotSupported = 3750 (&HEA6)
Const adErrDenyTypeNotSupported = 3751 (&HEA7)
Const adErrFeatureNotAvailable = 3251 (&HCB3)
Const adErrFieldsUpdateFailed = 3749 (&HEA5)
Const adErrIllegalOperation = 3219 (&HC93)
Const adErrIntegrityViolation = 3719 (&HE87)
Const adErrInTransaction = 3246 (&HCAE)
Const adErrInvalidArgument = 3001 (&HBB9)
Const adErrInvalidConnection = 3709 (&HE7D)
Const adErrInvalidParamInfo = 3708 (&HE7C)
Const adErrInvalidTransaction = 3714 (&HE82)
Const adErrInvalidURL = 3729 (&HE91)
Const adErrItemNotFound = 3265 (&HCC1)
Const adErrNoCurrentRecord = 3021 (&HBCD)
Const adErrNotExecuting = 3715 (&HE83) (undocumented)
Const adErrNotReentrant = 3710 (&HE7E)
Const adErrObjectClosed = 3704 (&HE78)
Const adErrObjectInCollection = 3367 (&HD27)
Const adErrObjectNotSet = 3420 (&HD5C)
Const adErrObjectOpen = 3705 (&HE79)
Const adErrOpeningFile = 3002 (&HBBA)
Const adErrOperationCancelled = 3712 (&HE80)
Const adErrOutOfSpace = 3734 (&HE96)
Const adErrPermissionDenied = 3720 (&HE88)
Const adErrPropConflicting = 3742 (&HE9E)
Const adErrPropInvalidColumn = 3739 (&HE9B)
Const adErrPropInvalidOption = 3740 (&HE9C)
Const adErrPropInvalidValue = 3741 (&HE9D)
Const adErrPropNotAllSettable = 3743 (&HE9F)
Const adErrPropNotSet = 3744 (&HEA0)
Const adErrPropNotSettable = 3745 (&HEA1)
Const adErrPropNotSupported = 3746 (&HEA2)
Const adErrProviderFailed = 3000 (&HBB8)
Const adErrProviderNotFound = 3706 (&HE7A)
Const adErrReadFile = 3003 (&HBBB)
Const adErrResourceExists = 3731 (&HE93)
Const adErrResourceLocked = 3730 (&HE92)
Const adErrResourceOutOfScope = 3735 (&HE97)
Const adErrSchemaViolation = 3722 (&HE8A)
Const adErrSignMismatch = 3723 (&HE8B)
Const adErrStillConnecting = 3713 (&HE81)
Const adErrStillExecuting = 3711 (&HE7F)
Const adErrTreePermissionDenied = 3728 (&HE90)
Const adErrUnavailable = 3736 (&HE98)
Const adErrUnsafeOperation = 3716 (&HE84)
Const adErrURLDoesNotExist = 3727 (&HE8F)
Const adErrURLNamedRowDoesNotExist = 3737 (&HE99)
Const adErrVolumeNotFound = 3733 (&HE95)
Const adErrWriteFile = 3004 (&HBBC)
Const adwrnSecurityDialog = 3717 (&HE85)
Const adwrnSecurityDialogHeader = 3718 (&HE86)

EventReasonEnum Description
Const adRsnAddNew = 1
Const adRsnClose = 9
Const adRsnDelete = 2
Const adRsnFirstChange = 11
Const adRsnMove = 10
Const adRsnMoveFirst = 12
Const adRsnMoveLast = 15
Const adRsnMoveNext = 13
Const adRsnMovePrevious = 14
Const adRsnRequery = 7
Const adRsnResynch = 8
Const adRsnUndoAddNew = 5
Const adRsnUndoDelete = 6
Const adRsnUndoUpdate = 4
Const adRsnUpdate = 3

EventStatusEnum Description
Const adStatusCancel = 4
Const adStatusCantDeny = 3
Const adStatusErrorsOccurred = 2
Const adStatusOK = 1
Const adStatusUnwantedEvent = 5

ExecuteOptionEnum Description
Const adAsyncExecute = 16 (&H10)
Const adAsyncFetch = 32 (&H20)
Const adAsyncFetchNonBlocking = 64 (&H40)
Const adExecuteNoRecords = 128 (&H80)
Const adOptionUnspecified = -1 (&HFFFFFFFF) (undocumented)

Field Description
Property ActualSize As Long
Property Attributes As Long
Property DataFormat As Unknown
Property DefinedSize As Long
Property Name As String
Property NumericScale As Byte
Property OriginalValue
Property Precision As Byte
Property Properties As Properties
Property Status As Long
Property Type As DataTypeEnum
Property UnderlyingValue
Property Value
Sub AppendChunk(ByVal Data)
Function GetChunk(ByVal Length As Long)

Field15 Description
Property ActualSize As Long
Property Attributes As Long
Property DefinedSize As Long
Property Name As String
Property NumericScale As Byte
Property OriginalValue
Property Precision As Byte
Property Properties As Properties
Property Type As DataTypeEnum
Property UnderlyingValue
Property Value
Sub AppendChunk(ByVal Data)
Function GetChunk(ByVal Length As Long)

Field20 Description
Property ActualSize As Long
Property Attributes As Long
Property DataFormat As Unknown
Property DefinedSize As Long
Property Name As String
Property NumericScale As Byte
Property OriginalValue
Property Precision As Byte
Property Properties As Properties
Property Type As DataTypeEnum
Property UnderlyingValue
Property Value
Sub AppendChunk(ByVal Data)
Function GetChunk(ByVal Length As Long)

FieldAttributeEnum Description
Const adFldCacheDeferred = 4096 (&H1000)
Const adFldFixed = 16 (&H10)
Const adFldIsChapter = 8192 (&H2000)
Const adFldIsCollection = 262144 (&H40000)
Const adFldIsDefaultStream = 131072 (&H20000)
Const adFldIsNullable = 32 (&H20)
Const adFldIsRowURL = 65536 (&H10000)
Const adFldKeyColumn = 32768 (&H8000)
Const adFldLong = 128 (&H80)
Const adFldMayBeNull = 64 (&H40)
Const adFldMayDefer = 2
Const adFldNegativeScale = 16384 (&H4000)
Const adFldRowID = 256 (&H100)
Const adFldRowVersion = 512 (&H200)
Const adFldUnknownUpdatable = 8
Const adFldUnspecified = -1 (&HFFFFFFFF) (undocumented)
Const adFldUpdatable = 4

FieldEnum Description
Const adDefaultStream = -1 (&HFFFFFFFF)
Const adRecordURL = -2 (&HFFFFFFFE)

Fields Description
Property Count As Long
Property Item(ByVal Index) As Field
Sub _Append(ByVal Name As String, ByVal Type As DataTypeEnum, [ByVal DefinedSize As Long], [ByVal Attrib As FieldAttributeEnumadFldUnspecified]) (undocumented)
Sub Append(ByVal Name As String, ByVal Type As DataTypeEnum, [ByVal DefinedSize As Long], [ByVal Attrib As FieldAttributeEnumadFldUnspecified], [ByVal FieldValue])
Sub CancelUpdate
Sub Delete(ByVal Index)
Sub Refresh
Sub Resync([ByVal ResyncValues As ResyncEnumadResyncAllValues])
Sub Update

Fields15 Description
Property Count As Long
Property Item(ByVal Index) As Field
Sub Refresh

Fields20 Description
Property Count As Long
Property Item(ByVal Index) As Field
Sub _Append(ByVal Name As String, ByVal Type As DataTypeEnum, [ByVal DefinedSize As Long], [ByVal Attrib As FieldAttributeEnumadFldUnspecified]) (undocumented)
Sub Delete(ByVal Index)
Sub Refresh

FieldStatusEnum Description
Const adFieldAlreadyExists = 26 (&H1A)
Const adFieldBadStatus = 12
Const adFieldCannotComplete = 20 (&H14)
Const adFieldCannotDeleteSource = 23 (&H17)
Const adFieldCantConvertValue = 2
Const adFieldCantCreate = 7
Const adFieldDataOverflow = 6
Const adFieldDefault = 13
Const adFieldDoesNotExist = 16 (&H10)
Const adFieldIgnore = 15
Const adFieldIntegrityViolation = 10
Const adFieldInvalidURL = 17 (&H11)
Const adFieldIsNull = 3
Const adFieldOK = 0
Const adFieldOutOfSpace = 22 (&H16)
Const adFieldPendingChange = 262144 (&H40000)
Const adFieldPendingDelete = 131072 (&H20000)
Const adFieldPendingInsert = 65536 (&H10000)
Const adFieldPendingUnknown = 524288 (&H80000)
Const adFieldPendingUnknownDelete = 1048576 (&H100000)
Const adFieldPermissionDenied = 9
Const adFieldReadOnly = 24 (&H18)
Const adFieldResourceExists = 19 (&H13)
Const adFieldResourceLocked = 18 (&H12)
Const adFieldResourceOutOfScope = 25 (&H19)
Const adFieldSchemaViolation = 11
Const adFieldSignMismatch = 5
Const adFieldTruncated = 4
Const adFieldUnavailable = 8
Const adFieldVolumeNotFound = 21 (&H15)

FilterGroupEnum Description
Const adFilterAffectedRecords = 2
Const adFilterConflictingRecords = 5
Const adFilterFetchedRecords = 3
Const adFilterNone = 0
Const adFilterPendingRecords = 1
Const adFilterPredicate = 4 (undocumented)

GetRowsOptionEnum Description
Const adGetRowsRest = -1 (&HFFFFFFFF)

IRecFields Description
Sub ADOCheck

IsolationLevelEnum Description
Const adXactBrowse = 256 (&H100)
Const adXactChaos = 16 (&H10)
Const adXactCursorStability = 4096 (&H1000)
Const adXactIsolated = 1048576 (&H100000)
Const adXactReadCommitted = 4096 (&H1000)
Const adXactReadUncommitted = 256 (&H100)
Const adXactRepeatableRead = 65536 (&H10000)
Const adXactSerializable = 1048576 (&H100000)
Const adXactUnspecified = -1 (&HFFFFFFFF)

LineSeparatorEnum Description
Const adCR = 13
Const adCRLF = -1 (&HFFFFFFFF)
Const adLF = 10

LockTypeEnum Description
Const adLockBatchOptimistic = 4
Const adLockOptimistic = 3
Const adLockPessimistic = 2
Const adLockReadOnly = 1
Const adLockUnspecified = -1 (&HFFFFFFFF) (undocumented)

MarshalOptionsEnum Description
Const adMarshalAll = 0
Const adMarshalModifiedOnly = 1

MoveRecordOptionsEnum Description
Const adMoveAllowEmulation = 4
Const adMoveDontUpdateLinks = 2
Const adMoveOverWrite = 1
Const adMoveUnspecified = -1 (&HFFFFFFFF)

ObjectStateEnum Description
Const adStateClosed = 0
Const adStateConnecting = 2
Const adStateExecuting = 4
Const adStateFetching = 8
Const adStateOpen = 1

Parameter Description
Property Attributes As Long
Property Direction As ParameterDirectionEnum
Property Name As String
Property NumericScale As Byte
Property Precision As Byte
Property Properties As Properties
Property Size As Long
Property Type As DataTypeEnum
Property Value
Sub AppendChunk(ByVal Val)

ParameterAttributesEnum Description
Const adParamLong = 128 (&H80)
Const adParamNullable = 64 (&H40)
Const adParamSigned = 16 (&H10)

ParameterDirectionEnum Description
Const adParamInput = 1
Const adParamInputOutput = 3
Const adParamOutput = 2
Const adParamReturnValue = 4
Const adParamUnknown = 0

Parameters Description
Property Count As Long
Property Item(ByVal Index) As _Parameter
Sub Append(ByVal Object As Object)
Sub Delete(ByVal Index)
Sub Refresh

PersistFormatEnum Description
Const adPersistADTG = 0
Const adPersistXML = 1

PositionEnum Description
Const adPosBOF = -2 (&HFFFFFFFE)
Const adPosEOF = -3 (&HFFFFFFFD)
Const adPosUnknown = -1 (&HFFFFFFFF)

Properties Description
Property Count As Long
Property Item(ByVal Index) As Property
Sub Refresh

Property Description
Property Attributes As Long
Property Name As String
Property Type As DataTypeEnum
Property Value

PropertyAttributesEnum Description
Const adPropNotSupported = 0
Const adPropOptional = 2
Const adPropRead = 512 (&H200)
Const adPropRequired = 1
Const adPropWrite = 1024 (&H400)

Record Description
Property ActiveConnection
Property Fields As Fields
Property Mode As ConnectModeEnum
Property ParentURL As String
Property Properties As Properties
Property RecordType As RecordTypeEnum
Property Source
Property State As ObjectStateEnum
Sub Cancel
Sub Close
Sub DeleteRecord(ByVal Source As String, ByVal Async As Boolean)
Sub Open(ByVal Source, ByVal ActiveConnection, ByVal Mode As ConnectModeEnum, [ByVal CreateOptions As RecordCreateOptionsEnumadFailIfNotExists], [ByVal Options As RecordOpenOptionsEnumadOpenRecordUnspecified], ByVal UserName As String, ByVal Password As String)
Function CopyRecord([ByVal Source As String], [ByVal Destination As String], ByVal UserName As String, ByVal Password As String, [ByVal Options As CopyRecordOptionsEnumadCopyUnspecified], ByVal Async As Boolean) As String
Function GetChildren As _Recordset
Function MoveRecord([ByVal Source As String], [ByVal Destination As String], ByVal UserName As String, ByVal Password As String, [ByVal Options As MoveRecordOptionsEnumadMoveUnspecified], ByVal Async As Boolean) As String

RecordCreateOptionsEnum Description
Const adCreateCollection = 8192 (&H2000)
Const adCreateNonCollection = 0
Const adCreateOverwrite = 67108864 (&H4000000)
Const adCreateStructDoc = -2147483648 (&H80000000)
Const adFailIfNotExists = -1 (&HFFFFFFFF)
Const adOpenIfExists = 33554432 (&H2000000)

RecordOpenOptionsEnum Description
Const adDelayFetchFields = 32768 (&H8000)
Const adDelayFetchStream = 16384 (&H4000)
Const adOpenAsync = 4096 (&H1000)
Const adOpenRecordUnspecified = -1 (&HFFFFFFFF)
Const adOpenSource = 8388608 (&H800000)

Recordset Description
Property AbsolutePage As PositionEnum
Property AbsolutePosition As PositionEnum
Property ActiveCommand As Object
Property ActiveConnection
Property BOF As Boolean
Property Bookmark
Property CacheSize As Long
Property Collect(ByVal Index) (undocumented)
Property CursorLocation As CursorLocationEnum
Property CursorType As CursorTypeEnum
Property DataMember As String
Property DataSource As Unknown
Property EditMode As EditModeEnum
Property EOF As Boolean
Property Fields As Fields
Property Filter
Property Index As String
Property LockType As LockTypeEnum
Property MarshalOptions As MarshalOptionsEnum
Property MaxRecords As Long
Property PageCount As Long
Property PageSize As Long
Property Properties As Properties
Property RecordCount As Long
Property Sort As String
Property Source
Property State As Long
Property Status As Long
Property StayInSync As Boolean
Sub _xResync([ByVal AffectRecords As AffectEnumadAffectAll]) (undocumented)
Sub _xSave(ByVal FileName As String, [ByVal PersistFormat As PersistFormatEnumadPersistADTG]) (undocumented)
Sub AddNew([ByVal FieldList], [ByVal Values])
Sub Cancel
Sub CancelBatch([ByVal AffectRecords As AffectEnumadAffectAll])
Sub CancelUpdate
Sub Close
Sub Delete([ByVal AffectRecords As AffectEnumadAffectCurrent])
Sub Find(ByVal Criteria As String, [ByVal SkipRecords As Long], [ByVal SearchDirection As SearchDirectionEnumadSearchForward], [ByVal Start])
Sub Move(ByVal NumRecords As Long, [ByVal Start])
Sub MoveFirst
Sub MoveLast
Sub MoveNext
Sub MovePrevious
Sub Open(ByVal Source, ByVal ActiveConnection, [ByVal CursorType As CursorTypeEnumadOpenUnspecified], [ByVal LockType As LockTypeEnumadLockUnspecified], [ByVal Options As Long-1])
Sub Requery([ByVal Options As Long-1])
Sub Resync([ByVal AffectRecords As AffectEnumadAffectAll], [ByVal ResyncValues As ResyncEnumadResyncAllValues])
Sub Save(ByVal Destination, [ByVal PersistFormat As PersistFormatEnumadPersistADTG])
Sub Seek(ByVal KeyValues, [ByVal SeekOption As SeekEnumadSeekFirstEQ])
Sub Update([ByVal Fields], [ByVal Values])
Sub UpdateBatch([ByVal AffectRecords As AffectEnumadAffectAll])
Function _xClone As _Recordset (undocumented)
Function Clone([ByVal LockType As LockTypeEnumadLockUnspecified]) As _Recordset
Function CompareBookmarks(ByVal Bookmark1, ByVal Bookmark2) As CompareEnum
Function GetRows([ByVal Rows As Long-1], [ByVal Start], [ByVal Fields])
Function GetString([ByVal StringFormat As StringFormatEnumadClipString], [ByVal NumRows As Long-1], ByVal ColumnDelimeter As String, ByVal RowDelimeter As String, ByVal NullExpr As String) As String
Function NextRecordset([RecordsAffected]) As _Recordset
Function Supports(ByVal CursorOptions As CursorOptionEnum) As Boolean
Sub EndOfRecordset(fMoreData As Boolean, adStatus As EventStatusEnum, ByVal pRecordset As _Recordset)
Sub FetchComplete(ByVal pError As Error, adStatus As EventStatusEnum, ByVal pRecordset As _Recordset)
Sub FetchProgress(ByVal Progress As Long, ByVal MaxProgress As Long, adStatus As EventStatusEnum, ByVal pRecordset As _Recordset)
Sub FieldChangeComplete(ByVal cFields As Long, ByVal Fields, ByVal pError As Error, adStatus As EventStatusEnum, ByVal pRecordset As _Recordset)
Sub MoveComplete(ByVal adReason As EventReasonEnum, ByVal pError As Error, adStatus As EventStatusEnum, ByVal pRecordset As _Recordset)
Sub RecordChangeComplete(ByVal adReason As EventReasonEnum, ByVal cRecords As Long, ByVal pError As Error, adStatus As EventStatusEnum, ByVal pRecordset As _Recordset)
Sub RecordsetChangeComplete(ByVal adReason As EventReasonEnum, ByVal pError As Error, adStatus As EventStatusEnum, ByVal pRecordset As _Recordset)
Sub WillChangeField(ByVal cFields As Long, ByVal Fields, adStatus As EventStatusEnum, ByVal pRecordset As _Recordset)
Sub WillChangeRecord(ByVal adReason As EventReasonEnum, ByVal cRecords As Long, adStatus As EventStatusEnum, ByVal pRecordset As _Recordset)
Sub WillChangeRecordset(ByVal adReason As EventReasonEnum, adStatus As EventStatusEnum, ByVal pRecordset As _Recordset)
Sub WillMove(ByVal adReason As EventReasonEnum, adStatus As EventStatusEnum, ByVal pRecordset As _Recordset)

Recordset15 Description
Property AbsolutePage As PositionEnum
Property AbsolutePosition As PositionEnum
Property ActiveConnection
Property BOF As Boolean
Property Bookmark
Property CacheSize As Long
Property Collect(ByVal Index) (undocumented)
Property CursorLocation As CursorLocationEnum
Property CursorType As CursorTypeEnum
Property EditMode As EditModeEnum
Property EOF As Boolean
Property Fields As Fields
Property Filter
Property LockType As LockTypeEnum
Property MarshalOptions As MarshalOptionsEnum
Property MaxRecords As Long
Property PageCount As Long
Property PageSize As Long
Property Properties As Properties
Property RecordCount As Long
Property Sort As String
Property Source
Property State As Long
Property Status As Long
Sub _xResync([ByVal AffectRecords As AffectEnumadAffectAll]) (undocumented)
Sub AddNew([ByVal FieldList], [ByVal Values])
Sub CancelBatch([ByVal AffectRecords As AffectEnumadAffectAll])
Sub CancelUpdate
Sub Close
Sub Delete([ByVal AffectRecords As AffectEnumadAffectCurrent])
Sub Find(ByVal Criteria As String, [ByVal SkipRecords As Long], [ByVal SearchDirection As SearchDirectionEnumadSearchForward], [ByVal Start])
Sub Move(ByVal NumRecords As Long, [ByVal Start])
Sub MoveFirst
Sub MoveLast
Sub MoveNext
Sub MovePrevious
Sub Open(ByVal Source, ByVal ActiveConnection, [ByVal CursorType As CursorTypeEnumadOpenUnspecified], [ByVal LockType As LockTypeEnumadLockUnspecified], [ByVal Options As Long-1])
Sub Requery([ByVal Options As Long-1])
Sub Update([ByVal Fields], [ByVal Values])
Sub UpdateBatch([ByVal AffectRecords As AffectEnumadAffectAll])
Function _xClone As _Recordset (undocumented)
Function GetRows([ByVal Rows As Long-1], [ByVal Start], [ByVal Fields])
Function NextRecordset([RecordsAffected]) As _Recordset
Function Supports(ByVal CursorOptions As CursorOptionEnum) As Boolean

Recordset20 Description
Property AbsolutePage As PositionEnum
Property AbsolutePosition As PositionEnum
Property ActiveCommand As Object
Property ActiveConnection
Property BOF As Boolean
Property Bookmark
Property CacheSize As Long
Property Collect(ByVal Index) (undocumented)
Property CursorLocation As CursorLocationEnum
Property CursorType As CursorTypeEnum
Property DataMember As String
Property DataSource As Unknown
Property EditMode As EditModeEnum
Property EOF As Boolean
Property Fields As Fields
Property Filter
Property LockType As LockTypeEnum
Property MarshalOptions As MarshalOptionsEnum
Property MaxRecords As Long
Property PageCount As Long
Property PageSize As Long
Property Properties As Properties
Property RecordCount As Long
Property Sort As String
Property Source
Property State As Long
Property Status As Long
Property StayInSync As Boolean
Sub _xResync([ByVal AffectRecords As AffectEnumadAffectAll]) (undocumented)
Sub _xSave(ByVal FileName As String, [ByVal PersistFormat As PersistFormatEnumadPersistADTG]) (undocumented)
Sub AddNew([ByVal FieldList], [ByVal Values])
Sub Cancel
Sub CancelBatch([ByVal AffectRecords As AffectEnumadAffectAll])
Sub CancelUpdate
Sub Close
Sub Delete([ByVal AffectRecords As AffectEnumadAffectCurrent])
Sub Find(ByVal Criteria As String, [ByVal SkipRecords As Long], [ByVal SearchDirection As SearchDirectionEnumadSearchForward], [ByVal Start])
Sub Move(ByVal NumRecords As Long, [ByVal Start])
Sub MoveFirst
Sub MoveLast
Sub MoveNext
Sub MovePrevious
Sub Open(ByVal Source, ByVal ActiveConnection, [ByVal CursorType As CursorTypeEnumadOpenUnspecified], [ByVal LockType As LockTypeEnumadLockUnspecified], [ByVal Options As Long-1])
Sub Requery([ByVal Options As Long-1])
Sub Resync([ByVal AffectRecords As AffectEnumadAffectAll], [ByVal ResyncValues As ResyncEnumadResyncAllValues])
Sub Update([ByVal Fields], [ByVal Values])
Sub UpdateBatch([ByVal AffectRecords As AffectEnumadAffectAll])
Function _xClone As _Recordset (undocumented)
Function Clone([ByVal LockType As LockTypeEnumadLockUnspecified]) As _Recordset
Function CompareBookmarks(ByVal Bookmark1, ByVal Bookmark2) As CompareEnum
Function GetRows([ByVal Rows As Long-1], [ByVal Start], [ByVal Fields])
Function GetString([ByVal StringFormat As StringFormatEnumadClipString], [ByVal NumRows As Long-1], ByVal ColumnDelimeter As String, ByVal RowDelimeter As String, ByVal NullExpr As String) As String
Function NextRecordset([RecordsAffected]) As _Recordset
Function Supports(ByVal CursorOptions As CursorOptionEnum) As Boolean

Recordset21 Description
Property AbsolutePage As PositionEnum
Property AbsolutePosition As PositionEnum
Property ActiveCommand As Object
Property ActiveConnection
Property BOF As Boolean
Property Bookmark
Property CacheSize As Long
Property Collect(ByVal Index) (undocumented)
Property CursorLocation As CursorLocationEnum
Property CursorType As CursorTypeEnum
Property DataMember As String
Property DataSource As Unknown
Property EditMode As EditModeEnum
Property EOF As Boolean
Property Fields As Fields
Property Filter
Property Index As String
Property LockType As LockTypeEnum
Property MarshalOptions As MarshalOptionsEnum
Property MaxRecords As Long
Property PageCount As Long
Property PageSize As Long
Property Properties As Properties
Property RecordCount As Long
Property Sort As String
Property Source
Property State As Long
Property Status As Long
Property StayInSync As Boolean
Sub _xResync([ByVal AffectRecords As AffectEnumadAffectAll]) (undocumented)
Sub _xSave(ByVal FileName As String, [ByVal PersistFormat As PersistFormatEnumadPersistADTG]) (undocumented)
Sub AddNew([ByVal FieldList], [ByVal Values])
Sub Cancel
Sub CancelBatch([ByVal AffectRecords As AffectEnumadAffectAll])
Sub CancelUpdate
Sub Close
Sub Delete([ByVal AffectRecords As AffectEnumadAffectCurrent])
Sub Find(ByVal Criteria As String, [ByVal SkipRecords As Long], [ByVal SearchDirection As SearchDirectionEnumadSearchForward], [ByVal Start])
Sub Move(ByVal NumRecords As Long, [ByVal Start])
Sub MoveFirst
Sub MoveLast
Sub MoveNext
Sub MovePrevious
Sub Open(ByVal Source, ByVal ActiveConnection, [ByVal CursorType As CursorTypeEnumadOpenUnspecified], [ByVal LockType As LockTypeEnumadLockUnspecified], [ByVal Options As Long-1])
Sub Requery([ByVal Options As Long-1])
Sub Resync([ByVal AffectRecords As AffectEnumadAffectAll], [ByVal ResyncValues As ResyncEnumadResyncAllValues])
Sub Seek(ByVal KeyValues, [ByVal SeekOption As SeekEnumadSeekFirstEQ])
Sub Update([ByVal Fields], [ByVal Values])
Sub UpdateBatch([ByVal AffectRecords As AffectEnumadAffectAll])
Function _xClone As _Recordset (undocumented)
Function Clone([ByVal LockType As LockTypeEnumadLockUnspecified]) As _Recordset
Function CompareBookmarks(ByVal Bookmark1, ByVal Bookmark2) As CompareEnum
Function GetRows([ByVal Rows As Long-1], [ByVal Start], [ByVal Fields])
Function GetString([ByVal StringFormat As StringFormatEnumadClipString], [ByVal NumRows As Long-1], ByVal ColumnDelimeter As String, ByVal RowDelimeter As String, ByVal NullExpr As String) As String
Function NextRecordset([RecordsAffected]) As _Recordset
Function Supports(ByVal CursorOptions As CursorOptionEnum) As Boolean

RecordsetEventsVt Description
Sub EndOfRecordset(fMoreData As Boolean, adStatus As EventStatusEnum, ByVal pRecordset As _Recordset)
Sub FetchComplete(ByVal pError As Error, adStatus As EventStatusEnum, ByVal pRecordset As _Recordset)
Sub FetchProgress(ByVal Progress As Long, ByVal MaxProgress As Long, adStatus As EventStatusEnum, ByVal pRecordset As _Recordset)
Sub FieldChangeComplete(ByVal cFields As Long, ByVal Fields, ByVal pError As Error, adStatus As EventStatusEnum, ByVal pRecordset As _Recordset)
Sub MoveComplete(ByVal adReason As EventReasonEnum, ByVal pError As Error, adStatus As EventStatusEnum, ByVal pRecordset As _Recordset)
Sub RecordChangeComplete(ByVal adReason As EventReasonEnum, ByVal cRecords As Long, ByVal pError As Error, adStatus As EventStatusEnum, ByVal pRecordset As _Recordset)
Sub RecordsetChangeComplete(ByVal adReason As EventReasonEnum, ByVal pError As Error, adStatus As EventStatusEnum, ByVal pRecordset As _Recordset)
Sub WillChangeField(ByVal cFields As Long, ByVal Fields, adStatus As EventStatusEnum, ByVal pRecordset As _Recordset)
Sub WillChangeRecord(ByVal adReason As EventReasonEnum, ByVal cRecords As Long, adStatus As EventStatusEnum, ByVal pRecordset As _Recordset)
Sub WillChangeRecordset(ByVal adReason As EventReasonEnum, adStatus As EventStatusEnum, ByVal pRecordset As _Recordset)
Sub WillMove(ByVal adReason As EventReasonEnum, adStatus As EventStatusEnum, ByVal pRecordset As _Recordset)

RecordStatusEnum Description
Const adRecCanceled = 256 (&H100)
Const adRecCantRelease = 1024 (&H400)
Const adRecConcurrencyViolation = 2048 (&H800)
Const adRecDBDeleted = 262144 (&H40000)
Const adRecDeleted = 4
Const adRecIntegrityViolation = 4096 (&H1000)
Const adRecInvalid = 16 (&H10)
Const adRecMaxChangesExceeded = 8192 (&H2000)
Const adRecModified = 2
Const adRecMultipleChanges = 64 (&H40)
Const adRecNew = 1
Const adRecObjectOpen = 16384 (&H4000)
Const adRecOK = 0
Const adRecOutOfMemory = 32768 (&H8000)
Const adRecPendingChanges = 128 (&H80)
Const adRecPermissionDenied = 65536 (&H10000)
Const adRecSchemaViolation = 131072 (&H20000)
Const adRecUnmodified = 8

RecordTypeEnum Description
Const adCollectionRecord = 1
Const adSimpleRecord = 0
Const adStructDoc = 2

ResyncEnum Description
Const adResyncAllValues = 2
Const adResyncUnderlyingValues = 1

SaveOptionsEnum Description
Const adSaveCreateNotExist = 1
Const adSaveCreateOverWrite = 2

SchemaEnum Description
Const adSchemaAsserts = 0
Const adSchemaCatalogs = 1
Const adSchemaCharacterSets = 2
Const adSchemaCheckConstraints = 5
Const adSchemaCollations = 3
Const adSchemaColumnPrivileges = 13
Const adSchemaColumns = 4
Const adSchemaColumnsDomainUsage = 11
Const adSchemaConstraintColumnUsage = 6
Const adSchemaConstraintTableUsage = 7
Const adSchemaCubes = 32 (&H20)
Const adSchemaDBInfoKeywords = 30 (&H1E)
Const adSchemaDBInfoLiterals = 31 (&H1F)
Const adSchemaDimensions = 33 (&H21)
Const adSchemaForeignKeys = 27 (&H1B)
Const adSchemaHierarchies = 34 (&H22)
Const adSchemaIndexes = 12
Const adSchemaKeyColumnUsage = 8
Const adSchemaLevels = 35 (&H23)
Const adSchemaMeasures = 36 (&H24)
Const adSchemaMembers = 38 (&H26)
Const adSchemaPrimaryKeys = 28 (&H1C)
Const adSchemaProcedureColumns = 29 (&H1D)
Const adSchemaProcedureParameters = 26 (&H1A)
Const adSchemaProcedures = 16 (&H10)
Const adSchemaProperties = 37 (&H25)
Const adSchemaProviderSpecific = -1 (&HFFFFFFFF)
Const adSchemaProviderTypes = 22 (&H16)
Const adSchemaReferentialConstraints = 9
Const adSchemaReferentialContraints = 9 (undocumented)
Const adSchemaSchemata = 17 (&H11)
Const adSchemaSQLLanguages = 18 (&H12)
Const adSchemaStatistics = 19 (&H13)
Const adSchemaTableConstraints = 10
Const adSchemaTablePrivileges = 14
Const adSchemaTables = 20 (&H14)
Const adSchemaTranslations = 21 (&H15)
Const adSchemaTrustees = 39 (&H27)
Const adSchemaUsagePrivileges = 15
Const adSchemaViewColumnUsage = 24 (&H18)
Const adSchemaViews = 23 (&H17)
Const adSchemaViewTableUsage = 25 (&H19)

SearchDirection Description
Const adSearchBackward = -1 (&HFFFFFFFF)
Const adSearchForward = 1

SearchDirectionEnum Description
Const adSearchBackward = -1 (&HFFFFFFFF)
Const adSearchForward = 1

SeekEnum Description
Const adSeekAfter = 8
Const adSeekAfterEQ = 4
Const adSeekBefore = 32 (&H20)
Const adSeekBeforeEQ = 16 (&H10)
Const adSeekFirstEQ = 1
Const adSeekLastEQ = 2

Stream Description
Property Charset As String
Property EOS As Boolean
Property LineSeparator As LineSeparatorEnum
Property Mode As ConnectModeEnum
Property Position As Long
Property Size As Long
Property State As ObjectStateEnum
Property Type As StreamTypeEnum
Sub Cancel
Sub Close
Sub CopyTo(ByVal DestStream As _Stream, [ByVal CharNumber As Long-1])
Sub Flush
Sub LoadFromFile(ByVal FileName As String)
Sub Open(ByVal Source, [ByVal Mode As ConnectModeEnumadModeUnknown], [ByVal Options As StreamOpenOptionsEnumadOpenStreamUnspecified], ByVal UserName As String, ByVal Password As String)
Sub SaveToFile(ByVal FileName As String, [ByVal Options As SaveOptionsEnumadSaveCreateNotExist])
Sub SetEOS
Sub SkipLine
Sub Write(ByVal Buffer)
Sub WriteText(ByVal Data As String, [ByVal Options As StreamWriteEnumadWriteChar])
Function Read([ByVal NumBytes As Long-1])
Function ReadText([ByVal NumChars As Long-1]) As String

StreamOpenOptionsEnum Description
Const adOpenStreamAsync = 1
Const adOpenStreamFromRecord = 4
Const adOpenStreamUnspecified = -1 (&HFFFFFFFF)

StreamReadEnum Description
Const adReadAll = -1 (&HFFFFFFFF)
Const adReadLine = -2 (&HFFFFFFFE)

StreamTypeEnum Description
Const adTypeBinary = 1
Const adTypeText = 2

StreamWriteEnum Description
Const adWriteChar = 0
Const adWriteLine = 1
Const stWriteChar = 0 (undocumented)
Const stWriteLine = 1 (undocumented)

StringFormatEnum Description
Const adClipString = 2

XactAttributeEnum Description
Const adXactAbortRetaining = 262144 (&H40000)
Const adXactAsyncPhaseOne = 524288 (&H80000) (undocumented)
Const adXactCommitRetaining = 131072 (&H20000)
Const adXactSyncPhaseOne = 1048576 (&H100000) (undocumented)