ACC: Creating a Snapshot Is Slower Than Creating a Dynaset (90098)


The information in this article applies to:

  • Microsoft Access 1.0
  • Microsoft Access 1.1
  • Microsoft Access 2.0
  • Microsoft Access for Windows 95 7.0
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("Employees", dbOpenDynaset)

   ' Dynaset example for Microsoft Access version 2.0:

        Set MySet = MyDB.OpenRecordset("Employees", DB_OPEN_DYNASET)

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

        Set MySet = MyDB.OpenRecordset("Employees", dbOpenSnapshot)

   ' Snapshot example for version 2.0:

        Set MySet = MyDB.OpenRecordset("Employees", DB_OPEN_SNAPSHOT)

REFERENCES

For more information about the OpenRecordset method, search the Help Index for "OpenRecordset."
Modification Type:MinorLast Reviewed:10/11/2006
Keywords:kbinfo kbProgramming KB90098
©2004 Microsoft Corporation. All rights reserved.