Q296389 ACC2000: Table Corruption after referential integrity checks.

Symptoms

When attempting to run an append query, you get the error:

“Microsoft Access can't append all the records in the append query”

“Microsoft Access set 0 field(s) to Null due to a type conversion failure, and it didn't add <number> record(s) to the table due to key violations, 0 record(s) due to lock violations, and 0 record(s) due to validation rule violations.”

“Do you want to run the action query anyway?”

To just ignore the error and run the query anyway click ‘Yes’. Or, for an explanation of the causes and a description of the violations click ‘Help’.

When attempting to export a table you get the error:

”The Microsoft Jet Database Engine could not find the Object ". Make sure the object exists and that you spelled its name correctly.”

After clicking OK you get the following:

“An error occurred trying to export the data from table 'tablename'. The data was not exported”

Also, when attempting to compact a database you get the error:

"Could not find field "Description"

Cause

This often occurs within a table which has ‘self-join’ and ‘Memo’ fields or has referential integrity enforced.

Resolution

Change Memo fields into Text fields, or, move the Memo fields into another table then use a 1:1 relationship.