DAO Object Library Compatibility

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

Microsoft Access 2000 includes DAO objects, methods, and properties that replace those in versions 1.x, 2.0, and 7.0. You'll need to replace the older language elements that Microsoft Access 2000 doesn't support with the ones provided in the DAO 3.6 object library.

You can use the following table to identify the objects, methods, and properties that aren't included in the Microsoft DAO 3.6 object library and the features that replace them. You can use the new items in the second column to modify code written in earlier versions of Microsoft Access.

For examples of how to modify your code, see Examples of Converting DAO Code.

Functionality not present in DAO 3.6 Recommended DAO 3.6 replacements
FreeLocks Idle method of the DBEngine object (not needed for Microsoft Access 2000 databases)
SetDefaultWorkspace DefaultUser/DefaultPassword properties of the DBEngine object
SetDataAccessOption IniPath property of the DBEngine object
Database.BeginTrans Workspace.BeginTrans
Database.CommitTrans Workspace.CommitTrans
Database.CreateDynaset Database.OpenRecordset of type dbOpenDynaset
Database.CreateSnapshot Database.OpenRecordset of type dbOpenSnapshot
Database.DeleteQueryDef Delete method of the QueryDefs collection
Database.ExecuteSQL Database.Execute method and Database.RecordsAffected property
Database.ListTables Database.TableDefs collection
Database.OpenQueryDef Database.QueryDefs collection
Database.OpenTable Database.OpenRecordset of type dbOpenTable
Database.Rollback Workspace.Rollback
ListFields method of the Table, Dynaset, and Snapshot objects Recordset.Fields collection
Table.ListIndexes TableDef.Indexes collection
QueryDef.CreateDynaset QueryDef.OpenRecordset
QueryDef.CreateSnapshot QueryDef.OpenRecordset
QueryDef.ListParameters QueryDef.Parameters collection
Dynaset object Dynaset-type Recordset object
Snapshot object Snapshot-type Recordset object
Table object Table-type Recordset object
CreateDynaset method of the Dynaset and QueryDef objects Recordset.OpenRecordset with dbOpenDynaset parameter
CreateSnapshot method of the
Dynaset and QueryDef objects
Recordset.OpenRecordset with dbOpenSnapshot parameter