Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Difference between Dynaset and Snapshot?

April 26, 2017difference Snapshot

0

Posted

Difference between Dynaset and Snapshot?

1 Answer

0

Posted

All Recordset objects are constructed using records (rows) and fields (columns). There are five types of Recordset objects: Table-type Recordset :: representation in code of a base table that you can use to add, change, or delete records from a single database table (Microsoft Jet workspaces only). Dynaset-type Recordset :: the result of a query that can have updatable records. 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 dynaset-type Recordset object can contain fields from one or more tables in a database. This type corresponds to an ODBC keyset cursor. Snapshot-type Recordset :: a static copy of a set of records that you can use to find data or generate reports. A snapshot-type Recordset object can contain fields from one or more tables in a database but can’t be updated. This type corresponds to an ODBC static cursor. Forward-only-type Recordset:: identical to a snapshot