MySQL Forums
Forum List  »  Microsoft Access

Mysql and access issue
Posted by: Andy Edwards
Date: January 31, 2010 12:15PM

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?

Options: ReplyQuote


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.