Linked tables showing "#Deleted"
Posted on 2004-09-05
I'm trying to set up a database that uses MySql table on the Internet, and went about it this way:
1. Built db in Access
2. Uploaded tables to MySql db
3. Deleted origninal tables from Access
4. Linked MySql tables
5. Created original relationships in Access
The tables exist on the Mysql server, appear to have the right structure and contain data, however when I try to view that data in Access, all columns and rows contain "#Deleted". Can anyone point me in the right direction to figure out where the problem is?