O'Reilly logo

Access™ 2007 VBA Programmer's Reference by Armen Stein, Geoffrey Griffith, Rob Cooper, Teresa Hennig

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

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

MethodDescription
RefreshRefreshes the collection
PropertyDescription
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 ...

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