UpdateOptions Property

Applies To

Bound Object Frame Control, Unbound Object Frame Control.

Description

You can use the UpdateOptions property to specify how a linked OLE object is updated.

Setting

The UpdateOptions property uses the following settings.

Setting

Description

Visual Basic

Automatic

(Default) Updates the object each time the linked data changes.

0

Manual

Updates the object only when the control’s Action property is set to acOLEUpdate or the link is updated with the OLE/DDE Links command on the Edit menu.

2


You can set the UpdateOptions property using the property sheet, a macro, or Visual Basic. You can also set this property in a control’s default control style.

The UpdateOptions property setting is also available through the OLE/DDE Links command on the Edit menu.

Remarks

Normally, the object is updated automatically whenever the linked data changes, but you can tell Microsoft Access to update the data only when it receives a specific instruction to do so. For example, if other users or applications can access or change linked spreadsheet data on a form, you can use this property to specify that the linked data only be updated when the database is opened in single-user mode.

When the UpdateOptions property is set to Manual, updates do not occur based on the Refresh Interval setting specified in the Advanced tab of the Options dialog box, available by clicking Options on the Tools menu.

Note When an object’s data is changed, the Updated event occurs.

See Also

Action Property, Class Property, OLEType Property, OLETypeAllowed Property, Updated Event.

Example

The following example sets the UpdateOptions property for an unbound object frame named OLE1 to update manually, and then uses the Action property to force an update of the OLE object in the control.


OLE1.UpdateOptions = 2.Action = acOLEUpdate