Difference between Dynaset and Snapshot?

Showing Answers 1 - 4 of 4 Answers

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

  Was this answer useful?  Yes


  • 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

  Was this answer useful?  Yes


  • 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.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions