MySQL with MS Access Front End

Bernhard Zweifel 41 Reputation points


I am migrating the linked data tables form MS Access to a MySQL Server. The linked tables are working fine, I have all the necessary read/write privileges.
I can add record to tables without any problems. But when I use a form with a subform to enter data the two separate tables refuse to update.
In the old configuration form has a primary key and field for data to be entered. When I moved to the subform in a second table a record would be created with its own primary key (autoincrement), a reference to the primary key of the main table and field for entering data in the second table.

If I try to to that with the linked table on the data server ODBC throughs an error.

What is going wrong, what do I do wrong?

Thanks for any suggestions, boz

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
845 questions
0 comments No comments
{count} votes