Preventing multiple users from updating the same record

[cooldisk2005]

All,
I know this one has to be simple, but I am probably trying to make this too hard I think

I have an access database that is on a network and is used by multiple people.

Is there a way to prevent multiple users from updating the same record?

I want to be able to have a lock on a record if someone is already updating that record.

Please help. Your help will surely be appreciated.

Thanks

 

[ItIsHardToProgram]

A very simple, yet not the best way, would be to have a row indicating weither it was updated or not (once updated through the form, set the value to true) and then, when some one wants to edit a record, test with a if dlookup() = true, you can then set your allow edit to false, or lock txtboxes or which ever suits you...

 

[ItIsHardToProgram]

Then again if you wish the user that made the record to be able to modify the record he already entered, another way would be to dlookup the username and store username in the table....

 

[cooldisk2005]

There is an easier way I found which doing this:

Tools/Options/Advanced tab for record locking

I think that should do the trick.

Thanks so much for your help.