Query Message Prompts

[Akourns]

I have a very large database that involes updating a case specific
number from an excell file ever so often. Multiple users log into the
database and permissions have been set accordingly so that only a very
few can even think to edit anything. I have set up the Excel file to
be linked and update whenever the database is opened, but I have to
run an update query to get all the items in the database to update
correctly. I have the query setup to run OnLoad so that end users
don't have to know how to run the query. What I am trying to figure
out is if there is any way for me to avoid having the end user have to
click through all the prompted messages associated with running an
update query. There are four pop ups that I would like to avoid, this
first being "You are about to run a query that will modify data in
your table". The rest follow suit as they would whenever you run an
update query, but I really would not like to have people faced with
such messages when loading the database. Is there anyway to avoid
these messages when running an update query?

Thanks

 

[Klatuu]

If you are using VBA to run the queries, I would first suggest you use the
Excute method rather than the RunSql method:

Currentdb.Execute queryname, dbFailOnError

It is much faster and doesn't trigger the warning messages.
You can also turn them off with
Docmd.SetWarings False
and on
Docmd.SetWarnings True

If you are using a macro to run the queries, use the SetWarnings Action to
turn them off and on.