The difficult I do immediately, the impossible takes a little bit longer.

"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,

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.

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.

Action Query Errors...  What do they mean?
Queries

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.

aaaaaaaaaaaaiii