Link to home
Start Free TrialLog in
Avatar of Zack
ZackFlag 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.
Avatar of Boyd (HiTechCoach) Trimmell, Microsoft Access MVP 2010-2015
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP 2010-2015
Flag of United States of America image

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.
Avatar of Zack

ASKER

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

In what way?
ASKER CERTIFIED SOLUTION
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Zack

ASKER

Cheers for the info replication looks to be exactly I what I might use.
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