ADO Delete Method

❮ Complete Recordset Object Reference

The Delete method is used to delete the current record or a group of records. After deleting a record, the deleted record remains current until you move to a different record.

Note: If you are in batch update mode the deletion happens when you call the UpdateBatch method.

Note: To use this method assure that the Recordset object allows record deletion.

Note: If this method fails, the provider will not stop the execution, but it will send a warning to the Errors Collection. 


objRecordset.Delete affectrecords

Parameter Description
affectrecords An AffectEnum value that specifies which records this method will delete. Default is adAffectCurrent

AffectEnum Values

Constant Value Description
adAffectCurrent 1 Deletes only the current record
adAffectGroup 2 Deletes only records that satisfy the Filter setting (Filter must be set to a FilterGroupEnum value or an array of Bookmarks)

❮ Complete Recordset Object Reference