>

Recordsets Collection

Description

The Recordsets collection contains all open Recordset objects in a Database object.

Remarks

When you use data access objects, you interact with data almost entirely using Recordset objects.

A new Recordset object is automatically added to the Recordsets collection when you open the Recordset object, and is automatically removed when you close it.

Your application can create as many Recordset object variables as needed. A Recordset object can refer to one or more tables, queries alone, or queries referenced by other Recordset objects in any combination. You can also have a Recordset object that refers to some or all of the fields or records in other Recordset objects.

Properties

Count Property.

Methods

Refresh Method.

See Also

Appendix, "Data Access Object Hierarchy."

Example

See the Recordset object example.

Example (Microsoft Access)

See the Recordset object example (Microsoft Access).