Set Up a Trusted Location (Folder) in Access

In this video, I will show you how to set up a Trusted Location (Folder) on your PC so that you can avoid seeing Microsoft's security warnings and have your VBA or macros disabled every time you open the database.

I will show you how to do this in Access itself for users who have the full version of Office installed. I will also show advanced users how to do this by editing the Windows Registry which will even work if you are running just the Access Runtime edition.

Gavin from Detroit, Michigan (a Gold Member) asks: I routinely get database file updates from my home office. Whenever I download a new file, I get yellow bar across the top of the screen that gives me a security warning and nothing in the database works. I can click to enable the content, but that's annoying to have to do it every time. Is there a way to disable that?

Connor from Galway, Ireland (a Platinum Member) asks: I've built my database following your videos, and everything works great. I've set up a bunch of users on my network with a split database using the Runtime edition of Access. They are getting the Microsoft Access Security Notice every time they open the database. How can I get rid of that on their PCs since they don't have the full version of Office?

Members

Members will learn how to use VBA to edit the Registry and write those keys for your users automatically without having to open the Registry Editor.

•  Extended Cut Video - Silver
•  Database Download - Gold

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!

Registry Key

HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\
Access\Security\Trusted Locations\

Suggested Course

• Access Beginner 2: https://599cd.com/ACB2

Links

• Split Database: https://599cd.com/Split
• Encrypt Front-End: https://599cd.com/ACCDE
• Runtime: https://599cd.com/Runtime
• Hide Folder: https://599cd.com/HideFolder
• Trusted Location: https://599cd.com/Trusted
• Access Updater: https://599cd.com/Updater
• Registry Keys: https://599cd.com/RegistryKeys - Gold
• Access Database Cloud: https://599cd.com/ADC

Learn More FREE Access Beginner Level 1 Access Level 2 for $1.00 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, trusted location, trusted folder, security warning, enable content, trust center, split database, encrypt, back-end, front-end, runtime, registry keys