Shailaja ICFAI

• Jul 16th, 2005

 

Dynaset-these tables can be used for both reading and editing 
Snapshot-only used for reading and cannot be editable

ramani

• Aug 5th, 2005

 

Dynaset type enables us to update data from more than one table. 
Snapshot type cannot be updated and does not reflect changes to data made by the users

vishnu

• Sep 8th, 2005

 

The dynaset?type Recordset object represents the result of a query on one or more tables. A dynaset?type Recordset object is a dynamic set of records that you can use to add, change, or delete records from an underlying database table or tables. 
A snapshot?type Recordset object is a static set of records that represents the results of a query.

Lakshmi Narang

• Apr 19th, 2006

 

Dynaset:1. Can be formed by large number of tables resulting in Virtual Tables.2. Does not store on the Machine but occupy temporary memory that is RAM.3. The changes made in the database can be reflected in the this.4. Allows operations like edit and update.SnapShot:1. Creates table on the machine and occupies space of the memory.2. Does not allow edit and update operations. 3. Can be used for small amount of data.