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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Information about character lost from MySQL to Access 4
Open MySQL ODBC Connection... 2
Access front end linked tables to MySQL without ODBC? 0
Problem with Import or Linked Tables with MySql 1
Query design 0
Linked Table Manager works one at a time 4
Table linked to ODBC 3
Specific Values List Missing 1

Top