I have a simple test form with one text box, READ and UPDATE buttons. User1 reads data using Recordset into the text field, changes data, so in the text box KeyPress event I set the Recordset.Edit, clicks the UPDATE button which updates the Recordset.Update. All done...
BTW the database is split with Front end and Back end on the shared drive.
Access is set with Default Open Mode – Shared, Default record locking – Edited Record.
Now I use the same app to test multi user. UserA and UserB both read the data and UserA first changes the data, the text box keypress event sets the Recordset.Edit. Now UserB also changes the data...Ah, I get an error - Another user has updated etc...But what I don't understand is why UserB does NOT get the "Write Conflict" dialog box with 'Save Record', 'Copy to Clipboard', and 'Drop Changes' buttons ????
And because UserB does not get "Write Conflict" dialog box, UserA makes the updates successfully and when UserB clicks the UPDATE button he also changes i.e. overwrites UserA changes without getting to READ back UserA's changes.
BTW the database is split with Front end and Back end on the shared drive.
Access is set with Default Open Mode – Shared, Default record locking – Edited Record.
Now I use the same app to test multi user. UserA and UserB both read the data and UserA first changes the data, the text box keypress event sets the Recordset.Edit. Now UserB also changes the data...Ah, I get an error - Another user has updated etc...But what I don't understand is why UserB does NOT get the "Write Conflict" dialog box with 'Save Record', 'Copy to Clipboard', and 'Drop Changes' buttons ????
And because UserB does not get "Write Conflict" dialog box, UserA makes the updates successfully and when UserB clicks the UPDATE button he also changes i.e. overwrites UserA changes without getting to READ back UserA's changes.
