>
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).