Field2.OriginalValue Property

Access Developer Reference

Note
ODBCDirect workspaces are not supported in Microsoft Office Access 2007. Use ADO if you want to access external data sources without using the Microsoft Access database engine.

Returns the value of a Field2 in the database that existed when the last batch update began (ODBCDirect workspaces only).

Syntax

expression.OriginalValue

expression   A variable that represents a Field2 object.

Remarks

During an optimistic batch update, a collision may occur where a second client modifies the same field and record in between the time the first client retrieves the data and the first client's update attempt. The OriginalValue property contains the value of the field at the time the last batch Update began. If this value does not match the value actually in the database when the batch Update attempts to write to the database, a collision occurs. When this happens, the new value in the database will be accessible through the VisibleValue property.