Environment: MS Access 97
Problem:
Trying to force a record to update using the recordset.Update
property. What syntax do I need to force a record to be updated? I
have searched the newsgroups and web and haven't found a solution that
works.
Thanks!
The following is the syntax from the help file:
recordset.Update (type, force )
The Update method syntax has the following parts.
Recordset: An object variable that represents an open, updatable
Recordset object.
Type: Optional. A constant indicating the type of update, as specified
in Settings (ODBCDirect workspaces only).
Force: Optional. A Boolean value indicating whether or not to force
the changes into the database, regardless of whether the underlying
data has been changed by another user since the AddNew, Delete, or
Edit call. If True, the changes are forced and changes made by other
users are simply overwritten. If False (default), changes made by
another user while the update is pending will cause the update to fail
for those changes that are in conflict. No error occurs, but the
BatchCollisionCount and BatchCollisions properties will indicate the
number of conflicts and the rows affected by conflicts, respectively
(ODBCDirect workspaces only).