Run Append Query in Multiuser Environment

T

Tasha

Is there any way to turn off the Action query confirming dialog boxes? I know you can go to tools, options and turn it off for you personally but is there anyway to turn it off for other users using the database on a network? I have a database that many beginner level users use. When the database is open it runs a append and delete query combination to move files from an in progress table to a completed table. Most of the users don't know what an append query is. I want to make it as simple as possible and fear that those dialog boxes will confuse them

Any help is greatly appreciated

Thanks!
 
R

Rick Brandt

Tasha said:
Is there any way to turn off the Action query confirming dialog boxes? I
know you can go to tools, options and turn it off for you personally but is
there anyway to turn it off for other users using the database on a
network? I have a database that many beginner level users use. When the
database is open it runs a append and delete query combination to move
files from an in progress table to a completed table. Most of the users
don't know what an append query is. I want to make it as simple as possible
and fear that those dialog boxes will confuse them.

CurrentDB.Execute "NameOfQuery",dbFailOnError
 

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

Top