ADCPROP_UPDATECRITERIA_ENUM

Applies to: Access 2013, Office 2013

Specifies which fields can be used to detect conflicts during an optimistic update of a row of the data source with a Recordset object.

Use these constants with the Recordset "Update Criteria" dynamic property, which is referenced in the ADO Dynamic Property Index and documented in the Microsoft Cursor Service for OLE DB documentation.

Constant

Value

Description

adCriteriaAllCols

1

Detects conflicts if any column of the data source row has been changed.

adCriteriaKey

0

Detects conflicts if the key column of the data source row has been changed, which means that the row has been deleted.

adCriteriaTimeStamp

3

Detects conflicts if the timestamp of the data source row has been changed, which means the row has been accessed after the Recordset was obtained.

adCriteriaUpdCols

2

Detects conflicts if any of the columns of the data source row that correspond to updated fields of the Recordset have been changed.

ADO/WFC equivalent

Package: com.ms.wfc.data

Constant

AdoEnums.AdcPropUpdateCriteria.ALLCOLS

AdoEnums.AdcPropUpdateCriteria.KEY

AdoEnums.AdcPropUpdateCriteria.TIMESTAMP

AdoEnums.AdcPropUpdateCriteria.UPDCOLS