January 2002
Beginner
576 pages
13h 23m
English
When DAO appeared in 1992, it worked exclusively with the Jet database engine. Starting with Access 97, DAO (3.5) supported ODBCDirect in addition to Jet, opening up access to enterprise servers such as SQL Server. DAO is organized into a hierarchy of collections and objects. This means that all tables, fields, queries, and so forth, are represented by objects arranged into collections. For example, the reports collection of the Application object contains all the reports that are currently open in the Access database. The Application object refers to the active Access application.
Think of objects as storehouses for collections, which in turn store other objects, and down the hierarchy it goes. For example, you can ...