This quick 2 minute video tutorial shows you how to handle Access security warning for version 2007 (which is the similar for Microsoft Access 2010).
Take a look…
Disable Microsoft Access Security Warning
Microsoft Access Security Warning – How To Disable This Warning (Access 2007 / 2010)
In this tutorial, handling Access security warning is a simple on and off switch via the trusted locations setting (Access options). This practice is fine if you are the author or you know who the author is and therefore safe to run.
But you are open to a potential macro virus threat if you lower this setting (to the lowest) that clearly states that is ‘not recommended‘. Consider instead learning to store Access database files in a trusted located folder (which is also available in Access options) and this will keep your current macro settings enforced but allow the folder location as the exception folder and allow instant access and bypass the Access security warning.
Want more help? why not get in contact with for a 30 minute personal consultation on anything Microsoft Access.