Refreshing Collections Only When Necessary

You can use the Refresh method to get an up-to-date view of a collection and its objects. This is particularly useful in multiuser environments. Unfortunately, this method is a time-consuming operation relative to most other DAO operations and should be used only when absolutely necessary.

As noted earlier in this chapter, the Microsoft Access CurrentDb function refreshes all of the collections in the current database. To improve performance, you can use the DBEngine(0)(0) syntax and refresh collections only as needed.

See Also For more information about refreshing collections, see “Refreshing Collections” earlier in this chapter.