Edit

Share via

ExecuteOptions property (RDS)

  • Article

Applies to: Access 2013, Office 2013

Indicates whether asynchronous execution is enabled.

Settings and return values

Sets or returns one of the following values.

Constant

Description

adcExecSync

Executes the next refresh of the Recordset synchronously.

adcExecAsync

Default. Executes the next refresh of the Recordset asynchronously.

Note

Each client-side executable file that uses these constants must provide declarations for them. You can cut and paste the constant declarations that you want from the file Adcvbs.inc, located in the C:\Program Files\Common Files\System\MSADC folder.

Remarks

If ExecuteOptions is set to adcExecAsync, then this asynchronously executes the next Refresh call on the RDS.DataControl object's Recordset.

If you try to call Reset, Refresh, SubmitChanges, CancelUpdate, or Recordset while another asynchronous operation that might change the RDS.DataControl object's Recordset is executing, an error occurs.

If an error occurs during an asynchronous operation, the RDS.DataControl object's ReadyState value changes from adcReadyStateLoaded to adcReadyStateComplete, and the Recordset property value remains Nothing.