Record Locking Problem

[kopy]

I have a client that has an application that uses a single MDB file and is multi-user. Occassionally, 2 users are editing the same record. The default record locking is set to "edited record" and the option to open databases using record-level locking is checked.

The first user to enter the record has no issue. The second user is allowed to start editing the record and everything appears normal. But when the second user leaves the record, they get and error messge and their changes are not saved.

Since the locking is set to the "edited record", shouldn't the second user have been told that the record is read only and they can not edit it?

Thanks for any help, Kopy

 

[RuralGuy]

I believe it is not the first user to retrieve the record that gets to save but the first user that actually saves. The method you describe would make sense but I don't believe that is the way Access works and unless you impliment your own version of "who has this record?", you're probably stuck with dealing with the problem after the fact. When you get the error, you will need to fetch the record again (requery or refresh, depending) to see what the other user has done to the record.

HTH RuralGuy (RG for short) acXP winXP Pro
Please respond to this forum so all may benefit