I created a macro that has a RunSQL action in it. Everytime it runs I'm prompted to verify that I want to allow these changes to the database. How do I stop the prompts from popping up?
Do this before the code that runs your SQL
DoCmd.SetWarnings False
now i run my code in this space and then after it's all said and done
DoCmd.SetWarnings True
I hope that this helps! It works for me every time!
-Josh ------------------
-JPeters These things take time...
Got a helpful tip for Access Users? Check out and contribute to 'How to Keep Your Databases from becoming Overwhelming!'
thread181-293590
jpeters@guidemail.com
------------------
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.