Another simple but useful way is to have an artificial column in the table ... call it something like “mod_count”

I think that's what the OP meant by "Add a version counter to each record," also known as "optomistic locking."