Created a Macro in Access 2007 to run a query. The query runs fine, database is trusted, the confrim action queries is off. When I setwarnings to No or Yes before the query, the macro hangs. When I remove the setwarnings, everything runs fine again, but I don't want the confirmation prompts. I would like to run this macro as a scheduled task so I do not want any prompts.