MSDN DAO Recordset: Recordset Operations

DAO Recordset: Recordset Operations

|  Overview |  How Do I |  FAQ |  Sample |  |  ODBC Driver List

This article discusses several key recordset operations, particularly those involving updating records. Topics covered include:

• Adding new records
  
  
• Editing existing records
  
  
• Deleting records
  
  
• Requerying recordsets

For related information about using recordsets, see the following articles:

• DAO Queries
  
  
• DAO: Creating, Opening, and Closing DAO Objects
  
  
• DAO Recordset: Creating Recordsets
  
  
• DAO Recordset: Recordset Navigation
  
  
• DAO Recordset: Bookmarks and Record Positions
  
  
• DAO Recordset: Seeking and Finding
  
  
• DAO Recordset: Binding Records Dynamically
  
  
• DAO Recordset: Caching Multiple Records for Performance
  
  
• DAO Record Field Exchange (DFX)
  
  
• DAO Recordset: Using Aggregate SQL Functions with MFC DAO Classes

Important   Your ability to update records requires that you have update permission for your database and that you have an updatable table-type or dynaset-type recordset. You can't update snapshot-type recordsets with the MFC DAO classes.