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
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
