Disabling Update Query Confirmation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using Access 2003 in a network environment is their a way of adding a macro
or code to the autoexec macro to disable having to confirm update queries?

I know how to do this using Tools/Options/Edit-Find but it only works for
the person who has logged on at that particular machine. If I move to
another, I have to do the same thing. I really don't want to have to do this
for hundreds of users at 80 machines.

Thanks in advance for your help.
 
n code before running the sql you can set the warnings to false

Docmd.setWarnings False

Run SQL

Docmd.SetWarnings True
' Dont forget to set it back to true
 

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

Turning off action query confirmation messages 1
Confirm Action Query 2
Append Query 3
Confirm action query runtime option 1
Append Query Issue 0
Confirm Table Deletion Box in Make Table Query 2
STOP Delete existing table confirmation 2
Run macro after closing a table or file.... 5

Back
Top