Runtime Access Query Confirmation? Why?

[jdbass]

I have an Access backend on the server and am attempting to distribute the front-end using Access Runtime. The problem is users with Runtime get all of the query confirmation messages...even though the database that they are using has them all turned off in the Options menu.

I know I can do SetWarnings False/True to work around this, but I want to know if there is an easier way. Thanks!

 

[jiqjaq]

You can use the SetOption to set the options which appear on the Options menu: SetOption "Confirm Action Queries", 0

See help topic for "Set Options from Visual Basic".