ADO Cancel Method


❮ Complete Command 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 Command Object Reference
Copyright 1999-2023 by Refsnes Data. All Rights Reserved.