My append query is not transferring all my data

P

Pipes77

Both in a citrix and non-citrix environment, my macro that contains an append
query is not transferring the data from one table to the other. There are no
errors given and it doesn't happen consistently
 
A

Allen Browne

How are you running your query?

If you turn SetWarnings off, and then RunSql or OpenQuery, you will not
receive any messages about what went wrong.

The alternative is to use the Execute method, with dbFailOnError, so you do
get notified.

Details in this article:
Action queries: suppressing dialogs, while knowing results
at:
http://allenbrowne.com/ser-60.html
 
Top