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.