O'Reilly logo

Access 2002 Programming by Example by Bob Villareal

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required