Confirm action query runtime option

  • Thread starter Thread starter Morris Neuman
  • Start date Start date
M

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?
 
Back
Top