Status Property (ADO Recordset)
Indicates the status of the current record with respect to batch updates or other bulk operations.
Returns a sum of one or more RecordStatusEnum values.
Use the Status property to see what changes are pending for records modified during batch updating. You can also use the Status property to view the status of records that fail during bulk operations, such as when you call the Resync, UpdateBatch, or CancelBatch methods on a Recordset object, or set the Filter property on a Recordset object to an array of bookmarks. With this property, you can determine how a given record failed and resolve it accordingly.