Here's the backstory:
My client uses a MS Access database to keep track of their orders inside a table let's say is called "ms_orders". We are building them a web application that serves as a portal for customers to view their orders. The portal is built using PHP/MySQL. As such we need a way to read this MS Access database inside the web application.
So far my best idea is to create a duplicate orders table inside MySQL, called "mysql_orders". Then in MS Access create a linked version of "mysql_orders". Finally, creating data macros inside MS Access such that when "ms_orders" is updated, inserted, deleted reflect those changes to "mysql_orders".
Does this sound like the best solution? Does anyone else have any ideas?
Thanks