Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

ACC2000: Table Corruption After Referential Integrity Checks


View products that this article applies to.

Symptoms

When you are running an append query, you receive the following error message:
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 ignore the error(s) and run the query, click Yes.
For an explanation of the causes of the violations, click Help.
-or-

If you try to export a table, you receive the following error message:
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 to the error message, you receive the following error message:
An error occurred trying to export the data from table 'tablename'. The data was not exported.
-or-

If you try to compact a database you, receive the following error message:
"Could not find field "Description"

↑ Back to the top


Cause

You may experience this behavior with a table that has a self-join and Memo fields, and has referential integrity enforced.

↑ Back to the top


Resolution

To resolve this issue, change the Memo fields to Text fields or move the Memo fields into a separate table, and then use a 1:1 relationship.

↑ Back to the top


Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

↑ Back to the top


Article Info
Article ID : 296389
Revision : 3
Created on : 1/1/0001
Published on : 1/1/0001
Exists online : False
Views : 298