• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 15. What Are the Data Access Obj... > Understanding Recordset Types

Understanding Recordset Types

A Recordset object represents the records in a table or the records returned by a query. A Recordset object can be a direct link to the table, a dynamic set of records, or a snapshot of the data at a certain time. Recordset objects are used to directly manipulate data in a database. They enable you to add, edit, delete, and move through data as required by your application. Access 97 supports three types of Recordset objects: dynasets, snapshots, and tables.

Dynasets

You can use a Recordset object of the dynaset type to manipulate local or linked tables or the results of queries. A dynaset is actually a set of references to table data. Using a dynaset, you can extract and update data from multiple tables—even tables from other databases. In fact, the tables containing the data included in a dynaset can even come from databases that are not of the same type (for example, Microsoft SQL Server, FoxPro, Paradox, and dBASE).


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint