DAO Objects and Collections Reference

See Also

DAO objects and collections provide a framework for using code to create and manipulate components of your database system. Objects and collections have properties that describe the characteristics of database components and methods that you use to manipulate them. Together these objects and collections form a hierarchical model of your database structure, which you can control programmatically.

Objects and collections provide different types of containment relations: Objects contain zero or more collections, all of different types; and collections contain zero or more objects, all of the same type. Although objects and collections are similar entities, the distinction differentiates the two types of relations.

In the following table, the type of collection in the first column contains the type of object in the second column. The third column describes what each type of object represents.

Collection Object Description
Connections CdbConnection Information about a connection to an ODBC data source (ODBCDirect workspaces only)
Containers CdbContainer Storage for information about a predefined object type (Microsoft Jet workspaces only)
Databases CdbDatabase An open database
None CdbDBEngine The Microsoft Jet database engine
Documents CdbDocument Information about a saved, predefined object (Microsoft Jet workspaces only)
Errors CdbError Information about any errors associated with this object
Fields CdbField A column that is part of a table, query, index, relation, or recordset
Groups CdbGroup A group of user accounts (Microsoft Jet workspaces only)
Indexes CdbIndex Predefined ordering and uniqueness of values in a table (Microsoft Jet workspaces only)
Parameters CdbParameter A parameter for a parameter query
Properties CdbProperty A built-in or user-defined property
QueryDefs CdbQueryDef A saved query definition
Recordsets CdbRecordset The records in a base table or query
Relations CdbRelation A relationship between fields in tables and queries (Microsoft Jet workspaces only)
TableDefs CdbTableDef A saved table definition (Microsoft Jet workspaces only)
Users CdbUser A user account (Microsoft Jet workspaces only)
Workspaces CdbWorkspace Asession of the Microsoft Jet database engine