Recordset.BatchCollisions property (DAO)

Applies to: Access 2013, Office 2013

Syntax

expression .BatchCollisions

expression A variable that represents a Recordset object.

Remarks

This property contains an array of bookmarks to rows that encountered a collision during the last attempted batch Update call. The BatchCollisionCount property indicates the number of elements in the array.

If you set the working Recordset object's Bookmark property to bookmark values in the BatchCollisions array, you can move to each record that failed to complete the most recent batch-mode Update operation.

After the collision records are corrected, you can call the batch mode Update method again. At this point DAO attempts another batch update, and the BatchCollisions property again reflects the set of records that failed the second attempt. Any records that succeeded in the previous attempt are not sent in the current attempt, as they now have a RecordStatus property of dbRecordUnmodified. This process can continue as long as collisions occur, or until you abandon the updates and close the result set.

This array is re-created each time you execute a batch-mode Update method.