Use DAO Recordsets

|  Overview |  FAQ |  Details |  Sample |  |  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