MySQL Write Conflict using MS Access

Posted on 2010-01-12
Medium Priority
Last Modified: 2012-08-13
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?
Question by:David Smithstein
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
LVL 20

Expert Comment

ID: 26297742
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

Author Comment

by:David Smithstein
ID: 26297788
What's the easiest way to do that without having to change every field on the form?

Author Comment

by:David Smithstein
ID: 26297914
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.

Accepted Solution

David Smithstein earned 0 total points
ID: 26309812
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.

Expert Comment

ID: 37332667
I disabled transaction support and continue getting write conflicts.

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question