How do I successfully link MySQL to Access for data entry purposes

[alycone]

I am having difficutly getting Access to allow data entry into MySQL tables when an autonumber has been assigned in the MySQL tables. Do I have to have an autonumber on the MySQL side? and if so how do I get Access to read it and write it to the form.

 

[AshleyRickards]

Verify that your SQL table has a primary key. SQL needs every table to have one for transaction processing.
Also, make sure your Access query contains this field. You should then be able to update and insert in your form.