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 Connection Information about a connection to an ODBC data source (ODBCDirect workspaces only)
Containers Container Storage for information about a predefined object type (Microsoft Jet workspaces only)
Databases Database An open database
None DBEngine The Microsoft Jet database engine
Documents Document Information about a saved, predefined object (Microsoft Jet workspaces only)
Errors Error Information about any errors associated with this object
Fields Field A column that is part of a table, query, index, relation, or recordset
Groups Group A group of user accounts (Microsoft Jet workspaces only)
Indexes Index Predefined ordering and uniqueness of values in a table (Microsoft Jet workspaces only)
Parameters Parameter A parameter for a parameter query
Properties Property A built-in or user-defined property
QueryDefs QueryDef A saved query definition
Recordsets Recordset The records in a base table or query
Relations Relation A relationship between fields in tables and queries (Microsoft Jet workspaces only)
TableDefs TableDef A saved table definition (Microsoft Jet workspaces only)
Users User A user account (Microsoft Jet workspaces only)
Workspaces Workspace A session of the Microsoft Jet database engine