>> Most apps then I'm assuming then following the last one in gets the changes.

Not necessarily. You could specify that the changes are only allowed if no-one else has changed the data. Doing something like:

UPDATE table
SET column = newvalue
WHERE pkcolumn = pk AND column = oldvalue

Now, only the first person in wins.

-Mike