• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 12. Access Visual Basic Tools, T... > DAO Collections and Objects

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 access a field object through the Fields collection in both object models.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint