question

BernhardZweifel-2715 avatar image
0 Votes"
BernhardZweifel-2715 asked

MySQL with MS Access Front End

Hi,

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

office-access-dev
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

0 Answers