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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Turn off warning message 3
Make Table Query 2
File Download - Security Warning 5
Strange warning message 1
Remove warning pop up choice 4
How to Silence messages on Make Table query? 3
Suppressing warning messages from MakeTable query 2
clearing confirm boxes does not stop warnings 2

Back
Top