MarkWaddington
Programmer
Hi,
I have a multiuser database set-up using Access 2K. I have split the database so the data resides on a network drive, and the application is on each user's computer.
I have tried to implement record-level locking but I cannot get it to work.
The main form in my database which will be accessed regularly is the "client" form, many users may be using this at one time.
I have checked/enabled the following options:
Tools/Options/Default record locking: Edited Record
Tools/Options: "Open Databases using record level locking"
I have also set the "record locks" property on my client form to edited record.
The scenario which I want to prevent is as follows:
User A logs on to the database, searches for a client record, opens the record and begins to edit it.
User B logs on, goes to the exact same form, opens the same record edits it (quickly) and saves the changes.
User A attempts to save his/her record and gets told of the fact somebody else has been to that record and changed it before him/her.
I don't want User B to be able to edit a record that is already open by another user. Is this possible?
Thanks in advance.
Mark Waddington.
I have a multiuser database set-up using Access 2K. I have split the database so the data resides on a network drive, and the application is on each user's computer.
I have tried to implement record-level locking but I cannot get it to work.
The main form in my database which will be accessed regularly is the "client" form, many users may be using this at one time.
I have checked/enabled the following options:
Tools/Options/Default record locking: Edited Record
Tools/Options: "Open Databases using record level locking"
I have also set the "record locks" property on my client form to edited record.
The scenario which I want to prevent is as follows:
User A logs on to the database, searches for a client record, opens the record and begins to edit it.
User B logs on, goes to the exact same form, opens the same record edits it (quickly) and saves the changes.
User A attempts to save his/her record and gets told of the fact somebody else has been to that record and changed it before him/her.
I don't want User B to be able to edit a record that is already open by another user. Is this possible?
Thanks in advance.
Mark Waddington.