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

Chapter 14. What Are ActiveX Data Object... > Selecting Among the Available Types ...

Selecting Among the Available Types of DAO Recordset Objects

Deciding which type of recordset to use involves looking at the task to determine which type is most appropriate. When fast searching is most important and it is not a problem to retrieve all the records, a table is the best choice. If you must retrieve the results of a query and your resultset needs to be editable, a dynaset is the best choice. If there is no need for the results to be updated, but the results must consist of a relatively small subset of the data, a snapshot is most appropriate.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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