Help Mirroring Database on access

Question

Hello i have an ODBC/MySQL connector to access our company database for Read Only no write. I want to be able to access a mirror copy of my sql database so that i can go in a read thru data and i can refresh it to see live data

Answer 1

That's good.

What we need to know as well are the answers to my other previous questions about what that "mirror copy" is.

In particular: "When you say you want a "mirror copy of [your] sql database, I assume you mean duplicate tables in a local accdb. Or do you mean a local MySQL database?"

We can infer, probably, that you mean you have tables in your local Access accdb which are the same as the tables in the MySQL database.

Is that correct?

Can we also assume that your local accdb has links to those MySQL tables? If not, please be specific about how you try to retrieve the data, not just "...playing with settings" which provides no actionable information.

It appears that the update to your local tables is successful sometimes. Sometimes there are errors, though. Please show us the errors! That'll help someone understand the reason for the problem and help diagnose the problem.

Answer 2

II only need to refresh it maybe once a day ive tried doing the import external data and playing with the settings there but i seems to be trying to update the db then erroring, or it will pull it once and not reupdate

Answer 3

When you say you want a "mirror copy of [your] sql database, I assume you mean duplicate tables in a local accdb. Or do you mean a local MySQL database?

How often do you need to refresh the mirrored database data?

What have you tried so far?

What worked well?

What has not worked?