vishnu bobade

• Sep 8th, 2005

 

A snapshot?type Recordset object is a static set of records that represents the results of a query. A snapshot?type Recordset object includes all values for all the requested fields in your query, whether you refer to them in code or not. A snapshot?type Recordset object requires fewer resources than the dynaset?type Recordset object, but the data in a snapshot?type Recordset object cannot be updated.  
 
As you move through a snapshot?type Recordset object for the first time, all data is copied first into memory and then, if the recordset is large, into a temporary Microsoft Jet database on the user's computer. You can scroll forward and backward through the resulting set of data.  
 
To create a snapshot?type Recordset object, specify the dbOpenSnapshot constant for the type argument of the OpenRecordset method.