How to suppress make table warning

  • Thread starter Thread starter Ben
  • Start date Start date
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
 
Ben,

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