Not showing messages with an Append Query

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

Guest

Dear Access people,

I have a database where I have set up an archive table using a flag field
from the main database. When I run the append query and there is data
already in the archive table, I get the message that there are certain rows
that will not be appended. How can I hide or not show that message? Or is
there a better way to set up an archive table? Many Thanks.

Neal
 
Neal said:
I have a database where I have set up an archive table using a flag field
from the main database. When I run the append query and there is data
already in the archive table, I get the message that there are certain rows
that will not be appended. How can I hide or not show that message? Or is
there a better way to set up an archive table?
Click to expand...


Use the Execute method instead of RunSQL.

Actually, it would probably be much faster to join the two
tables in the query so that you only try to add the
unmatched records.
 
Back
Top