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 |