My append query is not transferring all my data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top