Meaning...
This usually happens when you try to insert Text into a Numeric field.

To Resolve...
Remove offending Text OR just leave it alone because basically Access simply set the fields to Null.

and it didn't add XX record(s) to the table due to key violations,

Meaning...
1. There is a field or two that have been formatted to except a certain set of data and the data you are trying to
insert in the field(s) cannot go in because it will violate that format. Example…

Field1 can only accept values A and B. But you trying to append C to it. In this case there are 21 records that won't
append because of this.
Action Query Errors...  What do they mean?

"Microsoft Access can't append all records in the append query…

Microsoft Access set 0 field(s) to Null due to a type conversion failure,
Action queries Use Transaction’s. Having this feature set to Yes (see A) causes the results to be stored in a cache, as a single transaction, until you confirm, by clicking Yes. When it is set to No the results are immediately written to the table/field because it handles the change as a single action at a time.. This does cause your query to run faster, though I’ve noticed very little difference.

However, having it set to No means even if you click "No, I didn’t mean to do that" does not save any of the changes the query has already made even though the transactions were being processed separately.
The difficult I do immediately, the impossible takes a little bit longer.
Queries
Tips (Main)
Home
Using Parameters in a Crosstab Query
OrderBy OR Order By
Memo field is truncated when exported to Excel
Query Joins
Append and/or Update Data to Table Created Dynamically
OR

2. There is a field in your table that is formatted to accept specific data but you are trying to append NULL or
nothing to the field.

To Resolve ...
Resolve 1. Run an Unmatched query on the table that has the ’new’ records and the table that has the newly added
records to figure out which XX records did not get into the table. Repair and rerun your append query.

Resolve 2. Review the fields in your table and determine if any of them have a Default Value and do not allow Nulls.
Update the fields in the new data and rerun your append query.

0 record(s) due to lock violations,...
Meaning...
This usually happens when you try to insert data into a table but the table is actually opened and/or you have your
Default Record Locking set to ‘Edited Record’...

To Resolve…
In ToolsOptionsAdvanced...
Default Record Locking: No Locks should be checked

...and 0 record(s) to due to validation rule violations."

Meaning...
While this error sounds the same as… its difference is this Validation has most likely been set at the table level...

There is a field or two that have been formatted to except a certain set of data and the data you are trying to insert
in the field(s) cannot go in because it will violate that format. Example…

Field1 can only accept values A and B. But you are trying to append C to it. In this case there are 21 records that
won't append because of this.

To Resolve...
Run an Unmatched query on the table that has the ’new’ records and the table that has the newly added records to
figure out which 21 records did not get into the table.
This site uses cookies to collect data on usage. By continuing to browse this site you consent to this policy. Find out more here.