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 workspacesonly)
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
FieldsdvcolField CdbField A column that is part of a table, query, index, relation, or recordset
Groups CdbGroup A groupof 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 tableor 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 Asessionof the Microsoft Jet database engine