How to suppress make table warning

[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

 

[Steve Schapel]

Ben,

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

 

[Ben]

Steve,

Thanks, that worked.

Ben