Help with Access 2000 and MySQL version 4.1

[fdufresne]

I am running an Access 2000 database front-end with a MySql back end. I have the ODBC'S working and have the tables linked. I created a form to add a new person with the following info on the form:
Last Name, First Name, Address, Family Members, Shelter Name, Shelter Address, Shelter Phone Number, Shelter Info, and Comments.

When i hit the add new person command button, that was created in Access, i get a message that say's "Microsoft Office Access, You can't go to the specified record. You may have reached the end of the recordset."

I can enter info into the table in MySQL and then search it in Access. I am loggen in with all privilgees enabled.

I am new to MySQL and do not know how to make the add record button open a new record in MySQL.

Any help would be greatly appreciated.

Thanks.

 

[KLin]

you have to make sure you have the primary key identified in the linked table in access. If it doesn't know which field is the primary key, Access won't let you add new data into a table.

 

[fdufresne]

The primary key is identified, but I still get the same error message.