All database queries that return data usually transfer it to one or more ADO recordsets. In a database world, a recordset is always based on a table, a query, or a SQL command. A recordset is not considered to be a permanent object. Instead, the data is available only during the recordset object’s lifespan.
The query on which the recordset is based consists of at least one field. A Fields list is used to access the fields. The data determined in a recordset can be processed record by record, row by row, and forward or backward. A record pointer marks the current data row. ADO provides you with a number of methods, described in Tables 13-1 through 13-3, to determine the current record’s position.