Warning message

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

Is there any way to disable the warning message:
"The existing table 'xxx' will be deleted before you
run the query - Do you want to continue anyway?"
when I run a Make-Table query?

Thanks
 
You can try turning off the warnings from the Access menu
Tool-->Options-->Edit/Find, then under the "Confirmations" section untick
"Action Queries" (although I don't think this is a good idea given the
undesirable effects it may have elsewhere).

If you're using vba to create the tables you can switch the warnings off
then back on after creating the table with the following:

DoCmd.SetWarnings False
'Your SQL (DDL) goes here
DoCmd.SetWarnings True

HTH

Jamie
 
If you are calling your queries from forms or report you can disable the
warning message with : docmd.SetWarnings (false) then use docmd.SetWarnings
(True)
to turning it back on.
 
Back
Top