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.