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).
| Method | Description |
|---|---|
| Refresh | Refreshes the collection |
| Property | Description |
|---|---|
| Count | Returns 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 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.
