APPENDIX B Changes in the DAO Structure

KEVIN HOUSTOUN

Method Used Under Visual Basic 3 Method Used Under DAO 3 and Later
All CreateDynaset methods OpenRecordset method
All CreateSnapshot methods OpenRecordset method
All ListFields methods Fields collection
All ListIndexes methods Indexes collection
CompactDatabase statement DBEngine.CompactDatabase method
CreateDatabase statement DBEngine.CreateDatabase method
DBEngine.FreeLocks method DBEngine.Idle property
DBEngine.SetDefaultWorkspace method DBEngine.DefaultUser and DBEngine.Password properties

Method Used Under Visual Basic 3 Method Used Under DAO 3 and Later
DBEngine.SetDataAccessOption method DBEngine.IniPath property
Database.BeginTrans method WS.BeginTrans method
Database.CommitTrans method WS.CommitTrans method
Database.Rollback method WS.Rollback method
Database.DeleteQueryDef method Delete method
Database.ExecuteSQL method Execute method
Database.ListTables method TableDefs collection
Database.OpenQueryDef method QueryDefs collection
Database.OpenTable method OpenRecordset method
OpenDatabase statement DBEngine.OpenDatabase method
Querydef.ListParameters method Parameters collection
Recordset.Indexes collection Indexes collection
Snapshot object Recordset object
Dynaset object Recordset object
Table object Recordset object