MS Access/MySQL linked tables all fields display #Deleted but source tables are ok
Posted on 2013-10-30
(Note that this had been working until hardware replacement.)
ms access query with 2 linked tables shows all of the fields as #deleted. When I open one table everything is #Deleted, the other table is ok. the odbc driver is mysql 3.51. When I look at source mysql table it appears to be fine, fully populated.
I can't seem to clear #Deleted. If I import the table vs link, everything is ok, however this method gives me other issues.