Confirm action query runtime option

[Morris Neuman]

Hi,
I have a 2007 database and have unchecked/disabled in the Access Options
Editing, all the Confirm check boxes (Action Query,Record Changes, Document
Deletions). I have also disabled the I then used the Developer, Package
Solution and created a runtime version to deploy. My action queries are all
called using the OpenQuery in Macros.

When I run the runtime version on the machine that created the app, I don't
get prompted for action queries. However when copy the accdr file to a
machine that does not have Access and try to run the runtime app from that
machine I get prompted to confirm all the action queries. I saw a post that
suggests using the RunSQL instead of OpenQuery but could not input the RunSQL
in the macro screen.

How can I suppress all the action query messages?

 

[Gina Whipp]

Morris,

Try using...

DoCmd.SetWarnings False 'Turn off messages

DoCmd.SetWarnings True 'To turn on messages

....in your macros.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm