• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 21. Client/Server Strategies > Using Forward-Scrolling Snapshots

Using Forward-Scrolling Snapshots

If your data does not need to be updated and it is sufficient to move forward through a recordset, you might want to use a forward-scrolling snapshot. Forward-scrolling snapshots are extremely fast and efficient. You create a forward-scrolling snapshot by using the dbForwardOnly option of the OpenRecordset method. This renders the recordset forward-scrolling only, which means that you cannot issue a MovePrevious or MoveFirst method. You also cannot use a MoveLast method, because only one record is retrieved at a time. There is no concept of a set of records, so Access cannot move to the last record. This method of data retrieval provides significantly better performance than regular snapshots with large recordsets.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint