Run-time error 3197 on MS Access front-end to MySql Database
Posted on 2008-10-07
I'm having an issue with an MS Access (2003) front-end to a MySql database.
Under certain circumstances, I will get the errors
Write Conflict- The record has been changed...
Microsoft Visual Basic- Run-time error 3197...
About the Access front-end-
On the Access form, I have several text controls, a few buttons, a checkbox, and a subform.
The SubForm displays previously entered records.
The checkbox on the Form 'flags' a record/project as being a 'priority' project. This causes the 'flagged' record to be displayed in the SubForm to have a Red background (using conditional formatting)
The buttons on the Form sort the SubForms records according to either-
-the primary key (ascending or descding)
-the assigned 'project number'(ascending or descending)
-whether the record/project is 'flagged' as priority (orders 'flagged' records first).
For the most part, the front-end works without error-
-When the front-end starts, the SubForm records are sorted by default by the primary key.
-As such, I can select a record on the SubForm (which populates the Forms text fields with the records data) or scroll the Forms records, and use the Forms checkbox to flag a record as Priority. This works well- the record on the SubForm changes background to Red, or if unchecked, to White.
However, if I use one of the buttons to sort by 'project number' or by 'priority' flagged records, and then select a record and click the checkbox - then I get the errors stated at the beginning of this post. I'll get the error when the checkbox is clicked.
I've read that these errors are sometimes related to a control being bound or unbound (I'm still fuzzy here).
If it helps, the checkbox isn't bound. In its 'On-Click' event procedure, I've coded it to set the value of a text box which IS bound to the table.
Sorry if this is confusing. It's pretty much how I live my life.
If a sample of the code used on the buttons is desired, please ask.
Thanks all, for your time and your help.