Re: Ensuring users don't overwrite each other (NOT a newbie question)

"Oliver Cronk" <ocronk@essex.ac.uk> wrote in message news:NGENLNMKBJNBIAFJLPBHOEMPCBAA.ocronk@essex.ac.uk... > Thanks for that answer, you filled in some of the blanks for the table / > logging solution, but I am now looking at row locking instead of a seperate > table (and then doing things similar to what you outlined). Just a thought - if you have the user form echo a copy of the original data back (ie in addition to the modified data), you can compare it to the existing data and warn the user if the data has been changed in the interim. You must make the [compare-and-modify-if-unchanged] atomic, but that's okay, because it's all in the same script anyway - it becomes reasonable to do it as a transaction.