I use the Access 2007 runtime to run my Access database on a few client machines. How do I turn off the confirmation of Action Queries? On clients that are also running MS Access, I can simply open Access, go to Access Options and uncheck the box. When I make this change in Access, the same settings apply for the Runtime on that computer. Which makes me think perhaps there is a registry entry I can modify someplace? If anyone has an idea as to how to turn this off for the runtime please let me know.

Thanks!

http://www.mdbmakers.com/forums/showthread.php?t=2679

if you use

docmd.setwarnings false you wont be advised of any partial failures. also be sure to do
docmd.setwarnings true to turn them back on again

Thanks for the help! I will give that a try.