Disabling Update Query Confirmation

P

Principal

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.
 
O

Ofer

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
 
Top