>If I turn off locking table on Server, I think
>there will be another problem. Assume that User #1
>checks already that the data was not changed. If
>he does not lock table or that record, the data
>may be changed during the time he's just checked
>and the time he send update command.


What I meant was to only let one app do the actual locking.

HTH
Tom