The difficult I do immediately, the impossible takes a little bit longer.
"Microsoft Access can't append all records in the append query…
Action Query Errors... What do they mean?
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.