O'Reilly logo

Microsoft® Access® 2010 Programmer's Reference by Jerry Dennison, Geoffrey L. 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

Appendix B. DAO Object Method and Property Descriptions

This appendix provides a detailed alphabetical list of all the objects that DAO supports, including descriptions of their methods, properties, and collections. These descriptions are for reference purposes only, and you should consult the online Help for more in-depth descriptions.

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 2010, and they're reflected in the descriptions.

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 Remote Data Objects (RDO) that enabled this type of workspace. As a result, ODBCDirect is no longer supported in DAO.

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.

Containers Collection

The Containers collection contains all of the Container objects ...

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