Runtime Settings

[ListO]

Greetings, all.

I'm trying to turn a db into a distributable runtime version, using A97 ODE Tools. It all works fine except for one thing: I cannot see how to set the Access system settings in the runtime version.

Specifically, I want to turn off the "Action Queries confirmation" (found in the Tools / Options/ Edit/Find). This is turned off in the source database from which I made the runtime, but in the runtime version that I create, it's set to confirm all action queries. Because it's a runtime version, the F11 key doesn't work, and I cannot get to the Tools menu. I have quite a few action queries in the DB, and having to confirm each one destroys the useability. Any suggestions?

 

[John.Woody]

When writing the code for the query to run you need to turn off the warnings, but don't forget to turn them ack on again afterwards i.e.

DoCmd.SetWarnings False
DoCmd.OpenQuery "YourQueryName"
DoCmd.SetWarnings True

HTH
John