ADO: ActiveX Data Objects

Name

Record.DeleteRecord Method — (Versions 2.5, 2.6)

Synopsis

record.DeleteRecord Source, Async
                  

The DeleteRecord method deletes the resource represented by the current Record object, or another if specified.

Arguments

Source (String)

Optional. Specifies which resource to delete. If this argument is omitted, the resource represented by the current Record object will be deleted.

Async (Boolean)

Optional. Indicates whether this operation should be executed asynchronously.

Description

The DeleteRecord method deletes all children resources of the current resource as well.

The Record object should be closed immediately after calling the DeleteRecord method because its behavior would be unpredictable. At the very least, an error will occur when trying to work with a Record object that represents a deleted resource.

If the Record object was created from a Recordset object, you should either close and reopen the Recordset object or call Resync or Requery for the resource to be removed from it.

See Also

Recordset.Open Method, Recordset.Requery Method, Recordset.Resync Method