MySQL Forums
Forum List  »  Connector/ODBC

ODBC write conflict in MS Access when updating to same value
Posted by: Loic Joachim
Date: August 12, 2021 07:50PM

Hi all,

I have run into a bit of an issue, I am developing / updating a program in Microsoft Access and have found that when my code tells the database to update a record to the same value that it already was it gives me the error: "This record has been changed by another user..."

Such as:
Me!pnls_rte_profiles_id = Me!pr_rte (both values equal 10)
Me.Dirty = False (this is to save the change)

I have tested using a local table in Access and a MS SQL connector to an MS database and neither have this issue.

I have also tried changing connector version, I have tried 8.0.26, 8.0.1, 5.3.14 all with the same issue.

The program previously looked at MySQL server version 5 with ODBC connector version 3.51 and did not have this issue.

Any help would be greatly appreciated, Loic

Options: ReplyQuote


Subject
Written By
Posted
ODBC write conflict in MS Access when updating to same value
August 12, 2021 07:50PM


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.