I have an Access database that uses two ODBC connections. One is a driver that connects to our accounting system's data; the other connects to MySQL.



I'm currently trying to create a way to access this information in real time on our office's Android tablet. I've found several methods to use MySQL data on an Android device, but all the tables in MySQL relate to tables in the accounting data source and would be useless independently.

I considered creating a query to append/update data to a temp table in MySQL that would include full information from both data sources. It just defeats the purpose of the system if I have to manually sync data between the sources.

Any ideas/suggestions would be greatly appreciated!