You use Recordset objects to manipulate data in a database at the record level. There are five types of Recordset objects: table-type Recordset objects, dynaset-type Recordset objects, snapshot-type Recordset objects, forward-only-type Recordset objects, and dynamic-type Recordset objects. For more information about the types of Recordset objects, see “Manipulating Data” later in this chapter.
The Recordset object is somewhat different from other DAO objects discussed so far in that it exists only while your code or application is running. A Recordset object represents, in memory, a temporary set of records from one or more tables. Recordset objects are one of the most powerful objects in DAO because you can use them to programmatically access not only native Microsoft Jet tables, but any tables from ISAM data sources such as Microsoft FoxPro, or ODBC data sources such as Microsoft SQL Server. In addition, Recordset objects can be based on queries that join multiple tables from heterogeneous data sources.
The Recordsets collection contains all Recordset objects open in the current Database object. Note that a Recordset object is an object that you explicitly open through code. For example, in Microsoft Access, when you are viewing a table through the user interface, this table isn’t a Recordset object.
See Also For more information about Recordset objects, see Chapter 5, “Working with Records and Fields.”