Thursday, October 22, 2009

Error message while running an Append query

Append query in Microsoft Access database is primarily used to add records from one or more tables to another database table. Few benefits of using an append query are appending multiple records in one pass, review your selection criteria, and appending records when fields in the destination table do not exist. While appending the records using Append query is quite an easy task, the task may get halted due to corruption in database or when a table consists of Memo or self-join fields. In such situations, if you want to append the records, you will need to repair the database using an advanced repair access application.

For example, when you attempt to execute an append query to add some records in Employee table, you encounter the below 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 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.”


Two major reasons responsible for the occurrence of the error message are:

1.Employee table contains self-join and Memo fields, and has referential integrity enforced.
2.Access database corruption.


To resolve the above error message, you will need to follow the below steps:

Modify the Memo fields to Text fields, and then use a 1:1 relationship
Move the Memo fields to a different table, and then use a 1:1 relationship.
Use Compact and Repair utility to repair your database.

However, there is a possibility that after using the “Compact and Repair” utility, you might encounter below error message:

"Could not find field "Description"

To repair your database after the above error message appears, you will need to use powerful Access Database Repair utilities. With to-the-point documentation, highly graphical user-interface, and non-destructive nature, these access repair tools provide safe, comprehensive, and fast database repair.

No comments:

Post a Comment