DAO Collections and Objects
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 ...
Get Access 2002 Programming by Example now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
