MySQL Forums
Forum List  »  General

Synchronise between MySQL and Access
Posted by: Bart Hoeksel
Date: March 18, 2021 05:49AM

Hello,
I have an online MySQL (on a web server) and I need to synchronize a table to MS Access.
Currently, I have linked the table to Access by linking it as ODBC (linked table).
This works fine but when I want to update date from Access to mySQL,
I first get a message that the data on MySQL is different (I am offered to copy the date first) and then a message that the record can't be saved.
Check the image on https://farmpackteelt.nl/errors.png.

Would it probably be better to import the table from MySQL to Access and upload it again after editing? How would I best do this then?

Any suggestions?

Grtz Bart

Options: ReplyQuote


Subject
Written By
Posted
Synchronise between MySQL and Access
March 18, 2021 05:49AM


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.