How to suppress make table warning

B

Ben

Hi all,

I have Access 2003 on WinXP. I am running a macro with which includes
two queries, that uses SELECT...INTO. Is there any way to suppress the
warning messages about "dropping the existing tables" and "you are about
to insert so many records..."?

Thanks,

Ben
 
S

Steve Schapel

Ben,

Insert a SetWarnings/No action in your macro, immediately before the first
OpenQuery action.
 
Top