Skip navigation links

User Comments

Posted by Anders Madsen on January 16 2015 7:14pm[Delete] [Edit]

The "#DELETED# Records Reported by Access" error also results from having a primary key consisting of a string type, when the column includes "foreign characters" like e.g. ”æ” or ”…”.
It does not matter if the primary key is a single-column index or consists of other columns in a multiple-column index, even if the other columns are integer types.
It is a known problem since 2013 and is documented here: http://bugs.mysql.com/bug.php?id=70297
A work around, if you are the administrator of the MySQL table, is to change the primary key to a unique key, add an auto_increment column, and make the auto_increment column the primary key instead.
Afterwards, in Access, remember to update the link to the table.