I have written a sequence of action queries that a coworker needs to execute on a daily basis, and I'm trying to make it so that she doesn't have to approve every action query every time she runs the sequence. I created a macro, with the SetWarnings action, and set WarningsOn to "No". Then I saved the macro as AutoExec, and closed the database. When I reopened it and tried to run the action queries, the warning messages still popped up. Not sure why, or what I'm doing wrong.
I know in the past all I had to do was go to the Access Advanced Options and click a box that basically said "Turn off warnings for action queries." Life was good then.
Can anybody help?
Thank you