Snapshot Object (Professional Edition Only)
See Also Properties Methods
Description
A type of recordset Like a Table, a Snapshot has records (rows) and fields (columns). A Snapshot is a static picture of a set of records you can use to find data or generate reports. A Snapshot can contain fields from one or more tables in a database.
Remarks
In the Professional Edition, you can declare an object variable To create a Snapshot for an object variable, use the CreateSnapshot method on a Database, Dynaset, or another Snapshot. You can have more than one Snapshot object variable containing the same set of records.
Like all recordsets, when you create a Snapshot, the first record is the current record You can also use the Find methods, such as FindFirst, to move to a specific record. To cycle through all records, you can use the BOF and EOF properties to check for the beginning or end of the Snapshot.