Microsoft Cant Append All Records

[Matt]

Hi All,

Is there a way to get the information in this message through VBA
code?
I run the query from code, but it does not throw an error, so my error
trapping code will not catch it. I would like to somehow know when
this happens.

Thanks in advance!

 

[Allen Browne]

See:
Action queries: suppressing dialogs, while knowing results
at:
http://allenbrowne.com/ser-60.html

If you are seeking to understand why the error could occur, see:
Why can't I append some records? Trouble-shooting imports
at:
http://allenbrowne.com/casu-19.html