Access 2k Front-End With MySQL Back-End Write Conflict Question?????
Posted on 2007-03-21
I just converted my Access 2k back-end to MySQL and have run into this problem while entering data on a form in the Access Front-End. This form is a Work Orders form which contain various fields relating to the work order (customer, address, date, called in by, assigned to, call taken by, etc.) and it has a sub-form linked using the work order id where the problems reported by the customer are entered (using a combo box) of available problems to select from.
If I create a new work order and enter/change any of the fields on the order (on the main form) I can save the record with no problem. But, if I enter a problem for the order on the subform then try to save the order or change any other field on the main form of the order I will get the "Write Conflict" error message ....
"This record has been changed by another user since you started editing it., etc. etc." I then have the option to Copy to Clipboard or Drop Changes as Save Record is grayed out.
Any ideas why this is happening. I can use the Access back-end tables an obviously this did not occur.