Status property (ADO Recordset)

Applies to: Access 2013, Office 2013

Indicates the status of the current record with respect to batch updates or other bulk operations.

Return value

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.