Snapshot-Type Recordsets

When compared with dynasets, snapshots are fairly simple to understand — they are a complete copy of all the requested fields in your query. As you move through a snapshot-type Recordset for the first time, all data is copied first into memory and then, if need be, into a temporary Microsoft Jet database in the temporary directory on the user’s workstation. The resulting set of data is read-only and you can scroll through it forward and backward.

See Also For information about when the data is retrieved, see “Recordset Population” later in this chapter.