Microsoft KB Archive/90098

= ACC: Creating a Snapshot Is Slower Than Creating a Dynaset =

Article ID: 90098

Article Last Modified on 10/11/2006

-

APPLIES TO


 * Microsoft Access 1.0 Standard Edition
 * Microsoft Access 1.1 Standard Edition
 * Microsoft Access 2.0 Standard Edition
 * Microsoft Access 95 Standard Edition

-



This article was previously published under Q90098



SUMMARY
Advanced: Requires expert coding, interoperability, and multiuser skills.

A dynaset is a dynamic set of records that results from running a query or applying a filter. A snapshot is a static image of a set of data, such as the records displayed as the result of a query. Snapshots are not updateable whereas dynasets are updateable.

Creating a snapshot takes longer than creating a dynaset because the snapshot table is populated with data, and the dynaset is populated with bookmarks, which are significantly smaller than data.



MORE INFORMATION
The results from testing have resulted in only slight speed differences between the snapshot and the dynaset, but the dynaset has been found to be faster. The following example shows how to create both a dynaset and a snapshot in code: Dim MyDB As Database, MySet As Recordset Set MyDB = CurrentDB

' Dynaset example for Microsoft Access for Windows 95 version 7.0:

Set MySet = MyDB.OpenRecordset(&quot;Employees&quot;, dbOpenDynaset)

' Dynaset example for Microsoft Access version 2.0:

Set MySet = MyDB.OpenRecordset(&quot;Employees&quot;, DB_OPEN_DYNASET)

' Snapshot example for Microsoft Access for Windows 95 version 7.0:

Set MySet = MyDB.OpenRecordset(&quot;Employees&quot;, dbOpenSnapshot)

' Snapshot example for version 2.0:

Set MySet = MyDB.OpenRecordset(&quot;Employees&quot;, DB_OPEN_SNAPSHOT)

