Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 495
  • Last Modified:

MySQL Write Conflict using MS Access

I have most of the MySQL - Access integration issues solved.  
 - I have timestamp fields set up to autoupdate,
-  I ran queries to make sure older records had a value in the timestamp field,
- and I've been scouring my code for places that I was setting a value in a field that already had that exact value.

Now my problem.  If a user is on a form and checks a box, then changes their mind and unchecks it, they get a write conflict when the form closes and the data is posted to the MySQL table.

There's got to be some kind of ODBC configuration option, or some other setting in Access, that will allow this user behavior without producing the Write Conflict error message, right?
David Smithstein
David Smithstein
  • 3
1 Solution
Is your form 'bound' to the backend table?
Perhaps you should 'load' the data into the form (then close the connection).
When the user SAVES (click a button), the data on the form is 'filed' back to the table (open, update, close).
Scott C
David SmithsteinCEOAuthor Commented:
What's the easiest way to do that without having to change every field on the form?
David SmithsteinCEOAuthor Commented:
I'm missing something I think I already did.  My system isn't displaying the write conflict but a user's system I just set up is.  I'll post what I find out.
David SmithsteinCEOAuthor Commented:
I believe checking the box on the MySQL ODBC configuratioin screen, third tab, that disables transaction support prevents the write confict message and allows bound forms to work as designed.  It also makes my application run faster.
Eileen MurphyIndependent Application DeveloperCommented:
I disabled transaction support and continue getting write conflicts.

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now