Status Property

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

Return Values

Returns a Long value made up of a combination of the following constants:

Constant	Value	Description
adRecOK	0	The record was successfully updated.
adRecNew	1	The record is new.
adRecModified	2	The record was modified.
adRecDeleted	4	The record was deleted.
adRecUnmodified	8	The record was not modified.
adRecInvalid	16	The record was not saved because its bookmark is invalid.
adRecMultipleChanges	64	The record was not saved because it would have affected multiple records.
adRecPendingChanges	128	The record was not saved because it refers to a pending insert.
adRecCanceled	256	The record was not saved because the operation was canceled.
adRecCantRelease	1024	The new record was not saved because of existing record locks.
adRecConcurrencyViolation	2048	The record was not saved because optimistic concurrency was in use.
adRecIntegrityViolation	4096	The record was not saved because the user violated integrity constraints.
adRecMaxChangesExceeded	8192	The record was not saved because there were too many pending changes.
adRecObjectOpen	16384	The record was not saved because of a conflict with an open storage object.
adRecOutOfMemory	32768	The record was not saved because the computer has run out of memory.
adRecPermissionDenied	65536	The record was not saved because the user has insufficient permissions.
adRecSchemaViolation	131072	The record was not saved because it violates the structure of the underlying database.
adRecDBDeleted	262144	The record has already been deleted from the data source.

Remarks

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 Delete, 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.