ADO Objects

Connection Object

  Supported Unsupported
Properties Properties, ConnectionString, CommandTimeout, ConnectionTimeout, Version, IsolationLevel Errors, DefaultDatabase, Attributes, CursorLocation, Mode, Provider, State
Methods Close, Execute, BeginTrans, CommitTrans, RollbackTrans, Open OpenSchema, Cancel

Recordset Object

  Supported Unsupported
Properties Properties, AbsolutePosition, ActiveConnection, BOF, Bookmark, CacheSize, CursorType, EOF, Fields, LockType, MaxRecords, RecordCount, Source, DataSource, ActiveCommand AbsolutePage, EditMode, Filter, PageCount, PageSize, Sort, Status, State, CursorLocation, MarshalOptions, StayInSync, DataMember, Index
Methods AddNew, CancelUpdate, Clone, Close, Delete, Find, GetRows, Move, MoveNext, MovePrevious, MoveFirst, MoveLast, NextRecordset, Open, Requery, Resync, Update Cancel, CancelBatch, CompareBookmarks, GetString, Save, Seek, Supports, UpdateBatch

Fields Object

  Supported Unsupported
Properties Count, Item  
Methods   Refresh, Append, Delete

Field Object

  Supported Unsupported
Properties ActualSize, DefinedSize , Name, Type, Value, Precision, NumericScale, Properties, OriginalValue, UnderlyingValue, DataFormat
Methods AppendChunk,  GetChunk  

Command Object

  Supported Unsupported
Properties Properties, ActiveConnection, CommandText, CommandTimeout, Prepared, Parameters, CommandType Name, State
Methods CreateParameter, Execute Cancel

Parameters Object

  Supported Unsupported
Properties Count, Item  
Methods Append, Delete Refresh

Parameter Object

  Supported Unsupported
Properties Properties, Name, Value, Type, Direction, Precision, NumericScale, Size Attributes
Methods AppendChunk  

Properties Object

  Supported Unsupported
Properties Count, Item  
Methods   Refresh

Error Object

  Supported Unsupported
Properties Number, Source, Description, HelpFile, HelpContext, SQLState, NativeError  
Methods    


DAO Objects

DBEngine Object

  Supported Unsupported
Properties Properties, Version, LoginTimeout IniPath, SystemDB, DefaultType
Methods OpenDatabase, BeginTrans, CommitTrans, Rollback, OpenConnection, Idle CompactDatabase, RepairDatabase, RegisterDatabase, CreateDatabase, FreeLocks, SetDataAccessOption, ISAMStats, SetOption

Connection Object

  Supported Unsupported
Properties Name, Connect, Database, Transactions, QueryTimeout, RecordsAffected, StillExecuting, Updatable, QueryDefs, Recordsets
Methods Close, Execute, OpenRecordset Cancel, CreateQueryDef

Database Object

  Supported Unsupported
Properties Connect, Name, Version, Properties, Connection, Transactions QueryTimeout, RecordsAffected, QueryDefs, Recordsets, Updatable, CollatingOrder, ReplicaID, DesignMasterID
Methods BeginTrans, CommitTrans, Rollback, Close, Execute, ExecuteSQL, OpenRecordset, OpenTable, CreateDynaset, CreateSnapshot OpenQueryDef, CreateProperty, Synchronize, MakeReplica, NewPassword, PopulatePartial

Recordset Object

  Supported Unsupported
Properties AbsolutePosition, Bookmark, Fields, Properties, BOF, EOF, PercentPosition, Transactions, Type, RecordCount, CacheSize, StillExecuting, Connection, RecordStatus Bookmarkable, DateCreated, Filter, Index, LastModified, LastUpdated, LockEdits, Name, NoMatch, Sort, Updatable, Restartable, ValidationText, ValidationRule, CacheStart, EditMode, BatchSize, BatchCollisionCount, BatchCollisions, UpdateOptions
Methods AddNew, CancelUpdate, Close, Delete, Move, MoveNext, MovePrevious, MoveFirst, MoveLast, Requery, Update, GetRows, NextRecordset OpenRecordset, Edit, FindFirst, FindFirst, FindLast, FindNext, FindNext, FindPrevious, Seek, Clone, FillCache, CopyQueryDef, ListFields, Cancel

Fields Object

  Supported Unsupported
Properties Count, Item  
Methods   Refresh, Append, Delete

Field Object

  Supported Unsupported
Properties Attributes, Name, Size, Type, Value, SourceTable, FieldSize Properties, CollatingOrder, SourceField, OrdinalPosition, ValidationText, ValidateOnSet, ValidationRule, DefaultValue, Required, AllowZeroLength, DataUpdatable, ForeignName, OriginalValue, VisibleValue
Methods AppendChunk, GetChunk CreateProperty

Parameters Object

  Supported Unsupported
Properties Count, Item  
Methods Refresh  

Parameter Object

  Supported Unsupported
Properties Name, Value, Type, Direction Properties
Methods