D.1. DAO-Supported Objects

This section outlines the objects that are available in DAO. There have been some changes made to DAO in Access 2007, and they're reflected in the descriptions.

D.1.1. ODBCDirect

In addition to the Microsoft Access workspace, previous versions of DAO supported a second type of Workspace object called ODBCDirect. ODBCDirect workspaces are used against ODBC data sources, such as SQL Server. Beginning with Office 2007, Microsoft is no longer shipping RDO that enabled this type of workspace. As a result, ODBCDirect is no longer supported in DAO.

D.1.2. User-Level Security

Beginning with Access 2007, user-level security is no longer supported for new file formats. Thus, you cannot assign permissions to database objects such as tables and queries, or Access objects such as forms and reports in ACCDB files. User-level security is still supported for MDB files. The DAO object model related to users and groups, however, has been hidden. To view hidden members in an object model, right-click in the Object Browser and choose Show Hidden Members.

D.1.3. Containers Collection

The Containers collection contains all of the Container objects that are defined in a database (Microsoft Access databases only).

RefreshRefreshes the collection
CountReturns a count of Container objects in the collection

D.1.4. Container Object

The Container object contains a collection of Document objects that are of the same type. The Containers you ...

Get Access™ 2007 VBA Programmer's Reference now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.