Difference between Dynaset and Snapshot?

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

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

The dynasettype Recordset object represents the result of a query on one or more tables. A dynasettype 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 snapshottype Recordset object is a static set of records that represents the results of a query.

  3 Users have rated as useful.

  

Login to rate this answer.

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.

  2 Users have rated as useful.

  

Login to rate this answer.