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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Query Issue 0
Data changes in append query 1
Access 2010 append query to SQL is very slow 0
append query question in Access97 1
Invalid Argument - Append Query 1
Not appending correct data 3
Criteria in append querie 3
Appending null data and moving! 4

Back
Top