Cancel Method
Cancels execution of a pending asynchronous method call (ODBCDirect workspaces only).
Syntax
object.Cancel
The Cancel method syntax has these parts.
| Part | Description |
|---|---|
| object | A string expression that evaluates to one of the objects in the "Applies To" list. |
Remarks
Use the Cancel method to terminate execution of an asynchronous Execute, MoveLast, OpenConnection, or OpenRecordset method call (that is, the method was invoked with the dbRunAsync option). Cancel will return a run-time error if dbRunAsync was not used in the method you're trying to terminate.
The following table shows what task is terminated when you use the Cancel method on a particular type of object.
| If object is a | This asynchronous method is terminated |
|---|---|
| Connection | Execute or OpenConnection |
| QueryDef | Execute |
| Recordset | MoveLast or OpenRecordset |
An error will occur if, following a Cancel method call, you try to reference the object that would have been created by an asynchronous OpenConnection or OpenRecordset call (that is, the Connection or Recordset object from which you called the Cancel method).