Error Message While Running An Append Query Article

	1888 Articles Home \| Computer Articles \| Data Recovery Articles \| Website Promotion Articles	Data Recovery RSS
Error message while running an Append query

Stellar Phoenix Access Recovery is an efficient Access Repair utility to repair corrupt Access databases and recover almost all components like tables, forms, etc. The non-destructive tool is compatible with Microsoft Access 2007, 2003, XP (2002), and 2000, and performs complete repair in three simple steps.

Author: Colin Dolly

Article Tools:

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.”

Cause:

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.

Resolution:

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.

About Author

Colin Dolly is a self employed Internet entrepreneur and product reviewer. Our access recovery software completely recovers and access database repair database components such as, views, tables, forms, queries, macros, etc. This access recovery application supports Access 2007, 2003, XP and 2000. For More Details:- http://www.repair-access-file.com/

Article Source: http://www.1888articles.com/author-colin-dolly-23246.html

Error message while running an Append query