Related Documentation Download this Manual Excerpts from this Manual


This page has moved or been replaced. The new page is located here:

Please update any bookmarks that point to the old page.

Download this Manual
User Comments
  Posted by Anders Madsen on January 16, 2015
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:
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.
Sign Up Login You must be logged in to post a comment.