| Microsoft Office 2000/Visual Basic Programmer's Guide | |
One of the primary functions of a data access solution is working with records. The ADO object model supports a rich set of features for organizing, sorting, searching, updating, adding, and deleting data from a broad variety of data sources. The Recordset object alone provides 23 methods and 23 properties that give you a great deal of control over records in a database. In addition to these methods and properties, you can use the methods and properties of the Recordset object's Fields collection and the Field object to work with data at the field level. This section describes how to work with records and fields by using the ADO Recordset and Field objects.
Tip You can use a transaction to "wrap" a set of changes you make to the structure of a database; by using the transaction as a wrapper around the changes, you ensure that all work is performed as a single unit. For information about how to use transactions, see "Using Transactions" in Chapter 16, "Multiuser Database Solutions."