J
Jeff
Hello,
I am Programming/setting up a Netorked Database for the 1st time.
I need help in setting up so when a user is Editing a record & another user
on a different machine tries to Edit that same record, for it to display a
message saying something like "another user is cutrently Editing this record"
& not allow user to go in & Edit it. But would like if a user tries to VIEW
that record they can.
What I have:
- I have 2 sepereate DMB files, 1 the client & 1 the data & the Client is
Linked the the Tables from the Data one.
- The Client one I have on the Local C Drive on each workstation & the Data
I have on a Drive that is shared to all computers.
- I am testing at home so I have 3 computers networked with a Router
- In the Clients I have a Form with a Subform in it & when user DoubleClicks
on that record it opens up another Form that is Bound to a Table & displays
the data for that record that the user Double clicked on.
- In this Forms Propoerty I set the "Record Locks" property to "Edited Record"
- I also set in Tools / Options / Advanced tab / Default Record Locking to
"Edited Record"
But with all this it is not working, multiple users can edit the same record.
What needs to be done ? or what am I missing ?
Any help would be greatly appreciated.
Thank you,
Jeff
I am Programming/setting up a Netorked Database for the 1st time.
I need help in setting up so when a user is Editing a record & another user
on a different machine tries to Edit that same record, for it to display a
message saying something like "another user is cutrently Editing this record"
& not allow user to go in & Edit it. But would like if a user tries to VIEW
that record they can.
What I have:
- I have 2 sepereate DMB files, 1 the client & 1 the data & the Client is
Linked the the Tables from the Data one.
- The Client one I have on the Local C Drive on each workstation & the Data
I have on a Drive that is shared to all computers.
- I am testing at home so I have 3 computers networked with a Router
- In the Clients I have a Form with a Subform in it & when user DoubleClicks
on that record it opens up another Form that is Bound to a Table & displays
the data for that record that the user Double clicked on.
- In this Forms Propoerty I set the "Record Locks" property to "Edited Record"
- I also set in Tools / Options / Advanced tab / Default Record Locking to
"Edited Record"
But with all this it is not working, multiple users can edit the same record.
What needs to be done ? or what am I missing ?
Any help would be greatly appreciated.
Thank you,
Jeff