Stop message/warnings when running pass through query

When using Access 2007 pass through query to SQL 2005 it pops up warning about running the query. I would like to disable this in my macro that runs the queries. I have seen that SetWarnings can be used 2008 but cannot configure the Trust Center to get it to show up. I have attempted to disable as much of the Trust Center as I can figure out with no luck.
mark christensonAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
What warnings are you getting? If they're being generated from the server then I don't think there's much you can do about them ... can you screenshot them and post them here?
0
mark christensonAuthor Commented:
Here is the message...my guess its from Access. The last line tells me there should be a solution but searching help did not provide it. Mark

You are about to run a pass-through query that may modiFy data in your table.
Are you sure you want to run this type oF an SQL query
For Informateon on how to prevent this message From dispiaymg every time you run an SQL query, Click Help.

Yes No Help
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You should be able to turn this off in the Options dialog. In the main Access window, click Tools - Options, then select the Edit/Find tab and uncheck the "Action Queries" box in the Confirm section.

And no, I have no idea why the designers of Access would put this in the Edit/Find section ... it should be in the Tables/Queries <g> ...
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

mark christensonAuthor Commented:
Your instuctions make sense for Access 2003 but I don't see those options in Access 2007. Am I missing something?
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Sorry, didn't notice you were using 07.

Office Button > Access Options > Advanced > Untick "Confirm Action Queries"
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mark christensonAuthor Commented:
That is the solution. Thanks...Mark
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
So ... if that's the solution, why the B grade??
0
mark christensonAuthor Commented:
I do admit you provided a solution I could not find (even going back after you answered it) in Technet Plus if you read my original question I specify Access 2007. Did not mean to sound ungratefiul.. Mark
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
But .... I provided you an answer for Access 2007. I suggest you review the grading section in the Help document for EE:

http://www.experts-exchange.com/help.jsp#hi367

0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.