Use DAO Recordsets

Home |  Overview |  FAQ |  Details |  Sample |  Tutorial |  ODBC Driver List

These topics explain working with records in a DAO database using recordset objects.

What do you want to do?

General DAO Recordset Tasks

• Choose a DAO recordset type
  
  
• Create a DAO recordset
  
  
• Create a recordset from a DAO querydef

Recordset Design and Implementation:

• Learn about DAO record field exchange (DFX)
  
  
• Use DFX
  
  
• Customize DAO recordset code produced by the wizards
  
  
• Override CDaoRecordset::DoFieldExchange
  
  
• Initialize DAO recordset field data members
  
  
• Use the DAO record field exchange (DFX) functions

Recordset Performance and Convenience:

• Improve DAO recordset performance
  
  
• Cache multiple records with DAO for performance
  
  
• Double buffer a DAO recordset

Recordset Operations and Navigation:

• Add a record to a DAO recordset
  
  
• Edit a record in a DAO recordset
  
  
• Delete a record in a DAO recordset
  
  
• Requery a DAO recordset
  
  
• Filter a DAO recordset
  
  
• Navigate through records in a DAO recordset
  
  
• Seek a record in an indexed table-type DAO recordset
  
  
• Find records in a DAO recordset
  
  
• Use bookmarks in a DAO recordset
  
  
• Use absolute positioning in a DAO recordset
  
  
• Use percent positioning in a DAO recordset

Dynamic Binding of Recordsets:

• Use CDaoRecordset directly, without deriving a recordset class
  
  
• Dynamically bind data to a DAO recordset
  
  
• Dynamically set parameters to a DAO recordset
  
  
• Dynamically get parameter values from a DAO recordset