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?
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
Sorry, didn't notice you were using 07.

Office Button > Access Options > Advanced > Untick "Confirm Action Queries"
0
 
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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
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
 
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
 
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
All Courses

From novice to tech pro — start learning today.