Access.2007.VBA.Bibl..

FIGURE 5.7

The DAO 3.6 object model.

New Objects in the Access 2007 DAO Object Model ......................................

There are three new objects in the new object model: ComplexType, Field2, and

Recordset2. These objects are described in the following sections.

ComplexType

The ComplexTypeobject represents a multi-valued field and has its own Fields collection to hold

the values.

Field2

This object represents a field in an Access 2007 database. It has the new attributes outlined in

Table 5.1, as compared with the Field property, representing a field in an Access 2000 or Access

2002/2003 database.

DBEngine

Errors

Workspaces

Error

Workspace

Databases Database

Containers Container

Documents Document

Recordsets Recordset

Fields Field

Relations Relation

Fields Field

Groups Group

Users User

Users User

Groups Group

TableDefs TableDef

Fields Field

Indexes Index

Fields Field

QueryDefs QueryDef

Fields Field

Parameters Parameter

Working with Access Data 5