Dynasets Versus Snapshots for Query Optimization
Although the dynaset is the default record type in the query, the snapshot is faster. For example, if you are creating records to populate a control for a combo box you use a snapshot record type, provided that the read-only (non-updateable) attribute of this record type is acceptable. Another example is querying a huge table just to send the results to a report. You might consider using the snapshot record type. Just be sure that you don’t need to edit the results.
✓ For more information about creating records to populate a control for a combo box, see “The Power of Controls Revisited” in Chapter 7, “Exploring Objects.”
To change a query design’s record type, open the query in Design view, right-click ...
Get Access 2002 Programming by Example now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
