Appendix A. DAO 3.0/3.5 Collections, Properties, and Methods

Microsoft Access 97 comes with a utility known as the Object Browser , which can be used to explore the DAO object hierarchy. Figure 1.1 shows the Object Browser, which can be invoked from an Access code module by striking the F2 function key (or from the View menu).

The Object Browser

Figure A-1. The Object Browser

The Object Browser can be a very useful tool, but there are times when a hardcopy reference is also useful. Accordingly, this appendix contains information on the collections, properties, and methods of each of the objects in the DAO 3.0 object hierarchy (which underlies Access 95) and the DAO 3.5 (which underlies Access 97). If nothing else, this information should help point you to the right spot in the Access On-Line Help System.

In presenting this DAO reference, a table listing the classes and collections available in DAO is followed by tables listing the properties and methods exposed by each class, as well as the collections that are accessible from each object. The tables also indicate whether each item applies to DAO 3.0, DAO 3.5, or both. Finally, there is a summary description of each item.

DAO Classes

Class Name

Version

Description

Connection

3.5

An open ODBCDirect connection

Connections

3.5

A collection of Connection objects

Container

3.0/3.5

Storage for information about a predefined object type

Containers ...

Get Access Database Design and Programming, Second Edition 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.