A fixed copy of a set of records retrieved from the database and copied into memory. A snapshot derived from a Microsoft Jet-connected data source can’t be updated. Snapshot-type Recordset objects can be created from a base table, a query, or another Recordset. All SQL pass-through queries return snapshots.