Chapter 4
Just as the Connection object is your link to a database, the Recordset object is your link to its data. When you submit a query to a database, ADO stores the results in the Recordset object. You can then use the Recordset object to examine the query results. The Recordset object also supports other functionality such as updating, sorting, and filtering. The Recordset object exposes a Fields collection, with each Field object corresponding to a different field in the results of your query.