Avatar of Zack
Zack
Flag for Australia asked on

Database Synchronization Advice Access and MySQL

Heyas,

I need some advice I have two databases one is MySQL and the other is MS Access the Access one is being phased out however some it functions are yet built into the MYSQL db front end parts as of yet. My query is what would be the best wat to Synchronize changes across both databases I think of dumping the data from both db into a spreadsheet. That seems cumbersome to the extreme I would have to have fair bit of VBA code to pull that off, if a I could pull that off.

Any other ideas of how I might get around this problem.
Microsoft AccessDatabasesMySQL Server

Avatar of undefined
Last Comment
Jeffrey Coachman

8/22/2022 - Mon
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP 2010-2015

It is possible to create linked tables from the Access front end to the mySQL database. .The Access app could directly update and read from the mySQL database.
Zack

ASKER
I've explored that option too messy any other methods you know of?
Badotz

>>too messy

In what way?
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
ASKER CERTIFIED SOLUTION
Jeffrey Coachman

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Zack

ASKER
Cheers for the info replication looks to be exactly I what I might use.
Jeffrey Coachman

Great, Thanks

Just keep in mind that Replication will not be available if you upgrade to the .accdb format.

Hopefully by then you will have moved the data fully to MySQL (or MS SQL Server)

;-)

JeffCoachman