Skip to content

Latest commit

 

History

History
30 lines (19 loc) · 1.4 KB

relations-refresh-method-dao.md

File metadata and controls

30 lines (19 loc) · 1.4 KB
title TOCTitle ms:assetid ms:mtpsurl ms:contentKeyID ms.date mtps_version ms.localizationpriority
Relations.Refresh method (DAO)
Refresh Method
d71cecf2-da90-5f62-9e51-f994e660ad34
48547997
09/18/2015
v=office.15
medium

Relations.Refresh method (DAO)

Applies to: Access 2013, Office 2013

Updates the objects in the specified colletion to reflect the database's current schema.

Syntax

expression .Refresh

expression A variable that represents a Relations object.

Remarks

Use the Refresh method in multiuser environments in which other users may change the database. You may also need to use it on any collections that are indirectly affected by changes to the database. For example, if you change a Users collection, you may need to refresh a Groups collection before using the Groups collection.

A collection is filled with objects the first time it's referred to and won't automatically reflect subsequent changes other users make. If it's likely that another user has changed a collection, use the Refresh method on the collection immediately before carrying out any task in your application that assumes the presence or absence of a particular object in the collection. This will ensure that the collection is as up-to-date as possible. On the other hand, using Refresh can unnecessarily slow performance.