troubleshooting Question

Database Synchronization Advice Access and MySQL

Avatar of Zack
ZackFlag for Australia asked on
DatabasesMicrosoft AccessMySQL Server
6 Comments1 Solution509 ViewsLast Modified:
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.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros