Status

Syntax

RecordStatusEnum = recordsetobject.Status

Description

Returns a sum of one or more RecordStatusEnum values describing the status of the current record.

The Status property returns one or more of the RecordStatusEnum constants that describe the status of the current record when it is subject to batch operations such as CancelBatch, Resync, or UpdateBatch.

You can use this property to determine if an operation performed on a particular record failed or succeeded.

RecordStatusEnum Constants

Constant	Value	Description
adRecCanceled	0x100	Operation canceled and record not saved
adRecCantRelease	0x400	Cannot save new record because existing record is locked
adRecConcurrencyViolation	0x800	Optimistic concurrency in effect, record not saved
adRecDBDeleted	0x40000	Record has already been deleted
adRecDeleted	0x4	Record was successfully deleted
adRecIntegrityViolation	0x1000	Integrity constraints violation, record not saved
adRecInvalid	0x10	Bookmark is invalid, record not saved
adRecMaxChangesExceeded	0x2000	Too many pending changes, record not saved
adRecModified	0x2	Record was modified
adRecMultipleChanges	0x40	Record not saved because it would have affected other records
adRecNew	0x1	New record
adRecObjectOpen	0x4000	Conflict with open storage object, record not saved
adRecOK	0	Record was successfuly updated
adRecOutOfMemory	0x8000	Computer out of memory, record not saved
adRecPendingChanges	0x80	Due to pending insert, record not changed
adRecPermissionDenied	0x10000	User does not have permissions
adRecSchemaViolation	0x20000	Violation of underlying database, record not saved
adRecUnmodified	0x8	Record has not been changed

See Also

Filter, CancelBatch, Resync, UpdateBatch.

Example

rsChants.MoveFirst

Do While Not rsChants.EOF

If rsChants.Status = adRecModified Then

Debug.Print rsChants("BedrijfsNaam") & vbNewline

End If

rsChants.MoveNext

Loop