MYSQL as front-end to MS Access via LabView

[cyb_at]

Hello members,

There is a part in my project where a program writes to a MS Access database (DB). I want to be able to take this Access DB and use it to update a MySQL DB using LabView. I have already created the DB in MySQL with exactly the same structure as the DB in MS Access. Basically, what I am trying to do is that every time the MS Access DB is updated I want to be able to post-run a VI to update the MySQL DB. So MySQL DB is my front-end for MS Access. I have the data connectivity package and I have tried couple things but in vain. I can insert data into MySQLDB but I have not been able to update a specific existing column in a specific existing table. I have searched online too for possible ways to do it and most discussions/ solutions are for MS Access to be the front-end for MySQL (I need the opposite to be working). Some other discussions were for migrating MS Access to MySQL, but it is not what we are trying to do. The MS Access DB will always be there. I do have all permissions to read/write to both DB.

I will appreciate any suggestions or input you may be able to provide or if there is a better/ efficient way to do it.

[smercurio_fc]

Based on your description I don't see how either database is a "front-end" to either one. It sounds to me like you are updating the two databases in parallel. For it to be a "front-end" MySQL would need to update the Access database directly, not LabVIEW. So LabVIEW would know nothing about the Access database. This means all the work would be inside of MySQL (such as with triggers on table updates and insertions, which I'm not sure if MySQL even has).

I don't understand your statement about being unable to update a specific existing column in a specific existing table. What exactly are you trying? What VIs are you using? What are your inputs? Can you post your code and a quick overview of your schema?