MySQL ODBC Linked Table and View

J

julie

I am attempting to create some linked MySQL tables in an
Access 2000 database.
I can connect and link just fine. The problem lies in my
view of the linked table. The data in the fields display
as '#Deleted'.
What is really strange is that I can add a new record
through Access and it appends the table, but it will also
revert to the '#Deleted' view as soon as I leave that
record.

Help.....?
 
G

GVaught

You may need to make sure the MySQL table has a primary key set before it
links within Access.
 
Top