>>Yes it should work until you can figure out a cause of the problem.
>
>Out of curiosity, is this in effect at the record level or at the table level? Basically, if I can succeed to control that for the user itself, if someone else updates the table on another record, can this situation happens also?

Updating a single table cannot cause a deadlock.