Embedded subform crashes after adding 2 new records?

[thrainpa]

(SOLVED) Embedded subform crashes after adding 2 new records?

--- UPDATE (SOLVED) ---

My sincere apologies to anyone who read this wanted to help, it turns out during the import from Access DB to MySQL the Database lost it's 'auto-increment' status on all primary keys. This was my problem thank you to anyone who read this and thank you to jdraw helping me realize this.

Yes, not long after I fixed one issue I got another issue with a seperate subform (actually it happens on both but because of that I can rule out my workaround from my last issue as the source).

Basically I have Linked MySQL tables to my access Front-End, As far as reading and filtering the subforms, it works perfectly; I can add a record to it too, but as soon as I add a second record I get the error :

ODBC--call failed.
[MySQL][ODBC 5.1 Driver][mysqld-5.5.16-log]Duplicate entry '0' for key 'PRIMARY' (#1062)

Can anyone help?

--- UPDATE ---

It has NOW started doing it on the first time I try to add a record, making it impossible to add records in the

 

[jdraw]

It sounds like you are trying to add records with the same primary key.
Can you show us the table structure?
Can you show us the records you are trying to add when you get the error message?

What exactly was the issue you fixed?

 

[thrainpa]

It turns out that the issue was the DB import removed the 'auto-increment' status on my tables. Thank you for your help jdraw.