The Recordset Object

The Recordset object allows you to retrieve a set of records from a data source based on specified criteria. Recordsets can either be connected or disconnected. With connected recordsets, a connection to the database is maintained, and changes to the recordset are made to the underlying data source. With disconnected recordsets, the connection from the database is closed and you work with a local copy of the information. You can use both connected and disconnected recordsets to display data to a user on a form, for example. Examples later in this chapter will illustrate the difference between connected and disconnected recordsets.

0 0

Post a comment