ACC: Creating a Snapshot Is Slower Than Creating a Dynaset

• Microsoft Access versions 1.0, 1.1, 2.0, 7.0

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

Keywords          : JetRS kbprg PgmPrfm
Version           : 1.0 1.1 2.0 7.0
Platform          : WINDOWS
Hardware          : x86
Issue type        : kbinfo