>Dear Hilmar,
>
>Thank you for your suggested scenoria of the worst thing would happen.
>Do you agreed that I am not a careful programmer,if I ignore the conflict and implement no solving problem program segments. As there is only 2 user working on !!!
>
>With regards,
>
>Ransome

That's right. You need the something similar to the following pseudocode:

* For one record at a time:
if not TableUpdate() && single record, or all records? Check help for details
  MessageBox("Could not update record.")
  * See also aerror(), for more details.
  * Update can fail because of update conflict, or violation of some rule.
  if <the error is an update conflict, error number 1585
    TableRevert()
  endif
endif

If you are working with several tables, and you want to save "all or nothing", use transactions. See: BEGIN TRANSACTION, END TRANSACTION, ROLLBACK.

Hilmar.