Appendix A: DAO to ADO Quick Reference

The following table is intended to be a quick reference for determining how to map DAO properties and methods to ADO, ADOX, and JRO properties and methods. However, it is not intended to imply a direct, one-to-one mapping between the properties and methods listed. There may be subtle, or not so subtle, differences between the mapped properties and methods. For more detailed information on the ADO, ADOX, and JRO properties and methods, see the documentation for the object model. Use the information provided earlier in this article to map the code for common tasks that are performed using DAO to ADO, ADOX, and JRO code.

DAO object Property/method ADO/ADOX/
JROModel
Object Property/method
DBEngine DefaultType1 N/A N/A N/A
DBEngine DefaultPassword1 N/A N/A N/A
DBEngine DefaultUser1 N/A N/A N/A
DBEngine IniPath ADO Connection Jet OLEDB:Registry Path2
DBEngine LoginTimeout ADO Connection ConnectionTimeout
DBEngine SystemDB ADO Connection Jet OLEDB:System Database2
DBEngine Version ADO Connection Version
DBEngine BeginTrans ADO Connection BeginTrans
DBEngine CommitTrans ADO Connection CommitTrans
DBEngine Rollback ADO Connection RollbackTrans
DBEngine CompactDatabase JRO JetEngine CompactDatabase
DBEngine CreateDatabase ADOX Catalog Create
DBEngine CreateWorkspace ADO Connection Open
DBEngine Idle JRO JetEngine RefreshCache
DBEngine OpenDatabase ADO Connection Open
DBEngine RegisterDatabase1 N/A N/A N/A
DBEngine RepairDatabase1 N/A N/A N/A
DBEngine SetOption ADO Connection Properties3
Workspace IsolateODBCTrans ADO Connection Isolation Levels2
Workspace LoginTimeout ADO Connection ConnectionTimeout
Workspace Name1 N/A N/A N/A
Workspace Type1 N/A N/A N/A
Workspace UserName ADO Connection User Id2
Workspace BeginTrans ADO Connection BeginTrans
Workspace CommitTrans ADO Connection CommitTrans
Workspace Rollback ADO Connection RollbackTrans
Workspace Close ADO Connection Close
Workspace CreateDatabase ADOX Catalog Create
Workspace CreateGroup ADOX Groups Append
Workspace CreateUser ADOX Users Append
Workspace OpenDatabase ADO Connection Open
Database CollatingOrder ADO Connection Locale Identifier2
Database Connect ADO Connection ConnectionString
Database Name ADO Connection Data Source2
Database QueryTimeout ADO Connection CommandTimeout
Database Replicable JRO Replica MakeReplicable
Database ReplicaId JRO Replica ReplicaId
Database ReplicationConflictFunction JRO Replica ConflictFunction
Database RecordsAffected ADO Connection Execute(RecordsAffected)
Database Transactions ADO Connection Transaction DDL2
Database Updatable ADO Connection Mode
Database V1xNullBehavior N/A N/A N/A
Database Version ADO Connection DBMS Version2
Database Close ADO Connection Close
Database CreateProperty N/A N/A Not supported in this release
Database CreateQueryDef ADOX Command Dim New4
Database CreateRelation ADOX Key Dim New4
Database CreateTableDef ADOX Table Dim New4
Database Execute ADO Connection Execute
Database MakeReplica JRO Replica CreateReplica
Database NewPassword ADOX Catalog Modify
Database OpenRecordset ADO Recordset Open
Database PopulatePartial JRO Replica PopulatePartial
Database Synchronize JRO Replica Synchronize
Recordset AbsolutePosition ADO Recordset AbsolutePosition
Recordset BOF ADO Recordset BOF
Recordset EOF ADO Recordset EOF
Recordset Bookmark ADO Recordset Bookmark
Recordset Bookmarkable ADO Recordset Supports
Recordset CacheSize ADO Recordset Jet OLEDB:Fat Cursor Cache Size2
Recordset CacheStart1 N/A N/A N/A
Recordset DateCreated ADOX Table DateCreated
Recordset LastUpdated ADOX Table DateModified
Recordset EditMode ADO Recordset EditMode
Recordset Filter ADO Recordset Filter
Recordset Index ADO Recordset Index
Recordset LastModified1 N/A N/A N/A
Recordset LockEdits ADO Recordset LockType
Recordset Name1 N/A N/A N/A
Recordset NoMatch ADO Recordset Find
Recordset PercentPosition N/A N/A Not supported in this release.
Recordset RecordCount ADO Recordset RecordCount
Recordset RecordStatus ADO Recordset EditMode
Recordset Restartable1 N/A N/A N/A
Recordset Sort ADO Recordset Sort
Recordset Transactions1 N/A N/A N/A
Recordset Type ADO Recordset CursorType
Recordset Updatable ADO Recordset Recordset.Supports(adUpdate)
Recordset ValidationRule ADOX Table ValidationRule
Recordset ValidationText ADOX Table ValidationText
Recordset AddNew ADO Recordset AddNew
Recordset CancelUpdate ADO Recordset CancelUpdate
Recordset Clone ADO Recordset Clone
Recordset Close ADO Recordset Close
Recordset CopyQueryDef ADO Recordset Source
Recordset Delete ADO Recordset Delete
Recordset Edit1 N/A N/A N/A
Recordset FillCache1 N/A N/A N/A
Recordset FindFirst ADO Recordset Find
Recordset FindLast ADO Recordset Find
Recordset FindNext ADO Recordset Find
Recordset FindPrevious ADO Recordset Find
Recordset GetRows ADO Recordset GetRows
Recordset Move ADO Recordset Move
Recordset MoveFirst ADO Recordset MoveFirst
Recordset MoveLast ADO Recordset MoveLast
Recordset MoveNext ADO Recordset MoveNext
Recordset MovePrevious ADO Recordset MovePrevious
Recordset OpenRecordset ADO Recordset Open
Recordset Requery ADO Recordset Requery
Recordset Seek ADO Recordset Seek
Recordset Update ADO Recordset Update
QueryDef CacheSize ADO Command Jet OLEDB:Fat Cursor Cache Size2
QueryDef Connect ADO Command Jet OLEDB:Link datasource2
QueryDef DateCreated ADOX Procedure DateCreated
QueryDef LastUpdated ADOX Procedure DateModified
QueryDef KeepLocal JRO Replica Get/SetObjectReplicability
QueryDef LogMessages N/A N/A Not supported in this release.
QueryDef MaxRecords ADO Command MaxRecords
QueryDef Name ADOX Procedure Name
QueryDef ODBCTimeout ADO Command Jet OLEDB:ODBC Command Timeout2
QueryDef RecordsAffected ADO Command Execute(RecordsAffected)
QueryDef Replicable JRO Replica Get/SetObjectReplicability
QueryDef ReturnsRecords1 N/A N/A N/A
QueryDef SQL ADO Command CommandText
QueryDef Type N/A N/A Not supported in this release.
QueryDef Updatable N/A N/A N/A
QueryDef Close ADO/X Command / Procedure Set to Nothing
QueryDef CreateProperty N/A N/A Not supported in this release
QueryDef Execute ADO Command Command.Execute
QueryDef OpenRecordset ADO Recordset Open
TableDef Attributes ADOX Table Properties5
TableDef ConflictTable JRO Replica ConflictTables
TableDef Connect ADOX Table Jet OLEDB:Link Datasource2
TableDef DateCreated ADOX Table DateCreated
TableDef LastUpdated ADOX Table DateModified
TableDef KeepLocal JRO Replica Get/SetObjectReplicability
TableDef Name ADOX Table Name
TableDef RecordCount ADO Connection OpenSchema6
TableDef Replicable JRO Replica Get/SetObjectReplicability
TableDef ReplicaFilter JRO Filter FilterCriteria
TableDef SourceTableName ADOX Table Jet OLEDB:Remote Table Name2
TableDef Updatable N/A N/A N/A
TableDef ValidationRule ADOX Table Jet OLEDB:Table Validation Rule2
TableDef ValidationText ADOX Table Jet OLEDB:Table Validation Text2
TableDef CreateField ADOX Columns Append
TableDef CreateIndex ADOX Indexes Append
TableDef CreateProperty N/A N/A Not supported in this release.
TableDef OpenRecordset ADO Recordset Open
TableDef RefreshLink ADOX Table Jet OLEDB:Create Link2
Field AllowZeroLength ADOX Column Jet OLEDB:Allow Zero Length2
Field Attributes ADOX Column Properties5
Field CollatingOrder ADO/X Field/Column Collation Name2
Field DataUpdatable ADO Field Attributes
Field DefaultValue ADOX Column DefaultValue
Field FieldSize ADO Field ActualSize
Field ForeignName ADO Column RelatedColumn
Field Name ADO/X Field/Column Name
Field OrdinalPosition N/A N/A Not supported in this release.
Field Required ADO/X Field/Column Attributes
Field Size ADO/X Field/Column DefinedSize
Field SourceField N/A N/A Not supported in this release.
Field SourceTable N/A N/A Not supported in this release.
Field Type ADO/X Field/Column Type
Field ValidateOnSet ADOX Column Jet OLEDB:Validate On Set2
Field ValidationRule ADOX Column Jet OLEDB:Column Validation Rule2
Field ValidationText ADOX Column Jet OLEDB:Column Validation Text2
Field Value ADO Field Value
Index Clustered ADOX Index Clustered
Index DistinctCount ADO Connection OpenSchema6
Index Foreign ADOX Key Type
Index IgnoreNulls ADOX Index IndexNulls
Index Name ADOX Index Name
Index Primary ADOX Index PrimaryKey
Index Required ADOX Index Index.IndexNulls
Index Unique ADOX Index Unique
Index CreateField ADOX Column Dim New3
Index CreateProperty N/A N/A Not supported in this release
Relation Attributes ADOX Key Properties5
Relation ForeignTable ADOX Key RelatedTable
Relation Name ADOX Key Name
Relation PartialReplica JRO Filter FilterCriteria
Relation Table ADOX Key Parent Table Object7
Relation CreateField ADOX Column Dim New3
User Name ADOX User Name
User Password N/A N/A N/A
User PID N/A N/A N/A
User CreateGroup ADOX Groups Append
User NewPassword ADOX User ChangePassword
Group Name ADOX Group Name
Group PID N/A N/A N/A
Group CreateUser ADOX Users Append
Container AllPermissions ADOX User/Group GetPermissions8
Container Inherit ADOX User/Group Get/SetPermissions
Container Name1 N/A N/A N/A
Container Owner ADOX Catalog Get/SetObjectOwner
Container Permissions ADOX User/Group Get/SetPermissions
Container UserName ADOX User/Group Get/SetPermissions
Document AllPermissions ADOX User GetPermissions8
Document Container1 N/A N/A N/A
Document DateCreated ADOX Applicable Object DateCreated
Document LastUpdated ADOX Applicable Object DateModified
Document KeepLocal JRO Replica Get/SetObjectReplicability
Document Name1 N/A N/A N/A
Document Owner ADOX Catalog Get/SetObjectOwner
Document Permissions ADOX User/Group Get/SetPermissions
Document Replicable JRO Replica Get/SetObjectReplicability
Document UserName ADOX User/Group Get/SetPermissions

1. This property or method does not map to ADO, ADOX, or JRO. See the section "Obsolete Properties and Methods" earlier in this article.

2. This property is part of the object's Properties collection.

3. See the section "Setting Microsoft Jet Options" for more information on mapping the SetOption method to the Connection properties.

4. The object is creatable. Use the Visual Basic for Applications Dim New syntax to create a new object.

5. The DAO Attributes property is a bitmask of a number of constants that map to several properties in the ADOX model. For a detailed mapping of the DAO constants to ADOX properties, see the sections "Creating and Modifying Tables" and "Enforcing Referential Integrity."

6. The record count for a table can be retrieved via the Cardinality column in the TABLES_INFO schema rowset and the distinct count for an index can be retrieved via the Cardinality column in the INDEXES schema rowset.

7. The primary table in a relationship is represented in ADOX by the Table object that contains a primary Key object in its Keys collection. Primary keys are specified by a Type property value of adKeyPrimary.

8. Unlike the AllPermissions property in DAO, the GetPermissions property in ADOX does not add in the permissions that the user inherits from the groups to which that user belongs. This information must be extracted from the Group objects.