Run Append Query in Multiuser Environment

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

Guest

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!
 
Tasha said:
Is there any way to turn off the Action query confirming dialog boxes? I
Click to expand...
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
 
Back
Top