MySQL ODBC Linked Table and View

  • Thread starter Thread starter julie
  • Start date Start date
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.....?
 
You may need to make sure the MySQL table has a primary key set before it
links within Access.
 
Back
Top