Link to home
Start Free TrialLog in
Avatar of mark christenson
mark christensonFlag for United States of America

asked on

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.
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

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?
Avatar of mark christenson

ASKER

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
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> ...
Your instuctions make sense for Access 2003 but I don't see those options in Access 2007. Am I missing something?
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
That is the solution. Thanks...Mark
So ... if that's the solution, why the B grade??
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
But .... I provided you an answer for Access 2007. I suggest you review the grading section in the Help document for EE:

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