ADO Cancel Method
Complete Recordset Object Reference
The Cancel method cancels an execution of a method call.
The Cancel method cancels different tasks for each object. The table below shows what task is cancelled when this method is called:
| Object | Cancelled task |
|---|---|
| Command | Execute.
Note: The Options parameter of the Execute method must be set to adAsyncExecute or adAsyncFetch, before the Cancel method is called, otherwise a run-time error will occur |
| Connection | Execute or Open.
Note: The Options parameter of the Open method must be set to adSyncConnect, or the Options parameter of the Execute method be set to adAsyncExecute or adAsyncFetch, before the Cancel method is called, otherwise a run-time error will occur |
| Record | CopyRecord, DeleteRecord, MoveRecord, or Open
Note: The Options parameter of the Execute method must be set to adAsyncExecute or adAsyncFetch, before the Cancel method is called, otherwise a run-time error will occur |
| Recordset | Open |
| Stream | Open |
Syntax
object.Cancel
Complete Recordset Object Reference
