Write Conflict Using Access as Front End
I have an Access 2007 connecting to my MySQL table via ODBC. I've read everything I can find on this problem. I've got a TimeStamp column, no booleans and only one numeric and it defaults to zero. I was having trouble getting the dates in the right format so I exported the data from Excel as a tab delimited text file after changing all the dates to English(UK) YYYY-MM-DD.
The TimeStamp column was created via an SQL statement (alter table members change `tsChanged` `tsChanged` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP) since EarthLinks 2.11 phpMyAdmin would not let me do it directly.
Everything is fine for any new records I create in either Access or via phpMyAdmin directly on the server. However, any of the records I imported cannot be edited via Access - I get the dreaded Write Conflict message. I tried an update query on the MySQL server, and updated the TimeStamp to NOW() but that did not fix the problem - I could still edit the records I created after the import but not the imported ones.
Also, I checked the ODBC connector option for "Return matched rows instead of affected rows."
I am deperate. I've tried everything I can think of and every suggestion that I've found to no avail.
Please help if you can!
J. J. Campbell, Arlington, VA
Edited 2 time(s). Last edit at 08/19/2012 11:14AM by JJ Campbell.
Subject
Views
Written By
Posted
Write Conflict Using Access as Front End
4570
August 19, 2012 11:05AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.