Allowing two people to make changes at the same time

[brian0721]

Quick question...

How do I make it so that more than one person can be in the database at the same and both be able to save changes?

Thanks in advance,


Brian

 

[The_Doc_Man]

Well, there is no guarantee because Access doesn't do record-level locking. However, you first have to set locking to Optimistic so that lock lifetime is minimum. Second, set your forms for RecordLocks = edited record as opposed to all records

This still won't help if you have two users hitting exactly the same record at exactly the same time.

 

[brian0721]

Thanks alot, that works perfectly


--Brian