Mysql and access issue
Hi,
I have a strange problem.
I have an MS Access db link to a MySQL backend using ODBC link. Seems to work fine.
If I open a table and add or change a record in a table, all works fine.
If I open a table and edit a field and move off the record, the data saves fine.
If I open a table and edit a field and then remove the text I entered, when I move off the record, Access reports that Me and another user have edited the same data and I can not save.
Seems that editing and then removing the edit before moving off the record causes this error. I am guessing since the data is not different, something is causing this message. In VBA code, I retrieve a record, .edit, move space to a text field that is already blank, then on the .update (get error) the message error number = 3197.
Anybody have any info on this issue?
Subject
Views
Written By
Posted
Mysql and access issue
2852
January 31, 2010 12:15PM
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.