The database files used throughout this course make use of visual basic code, macros, and other elements that will cause Access to warn you each time you open a new file. Access will prevent the database from functioning properly unless permission is granted to run the code. We can fix this by adding the exercise folder to a list of trusted locations.
- [Voiceover] The database files used throughout this course make use of Visual Basic code, macros, and other elements that will cause Access to warn you each time you open up a new file. You'll see this warning as this yellow bar across the top of the screen here. These warnings indicate that Access will prevent the code from running properly and might keep the databases on your computer from function the same way that you see on my screen. We can fix this by pressing this Enable Content button here, at the top of each file. Now rather than having to do this for each and every exercise file, what we can do is add the exercise files to a list of trusted locations.
To do that, I'm gonna come up here to the File tab, and then we'll come down to Options. On the Access Options screen, we're going to go into the Trust Center, here at the very bottom, and then I'll press the Trust Center Settings button, way over here on the far right. In the Trust Center window, I'm gonna come up and press the Trusted Locations button here, and we'll add in the exercise files to a list of trusted locations by coming down here and pressing Add New Location. That'll allow me to browse out to my desktop, where I'll find the Exercise Files folder here, I'll select it, and press OK.
Then, I wanna make sure that I am checking on this box here that says sub-folders of this location are also trusted. That'll ensure that all the databases within the chapter folders are also trusted. We can add a description here in order to remind us about why we added this location to our trusted list. I'm gonna type in Access 2016 Advanced Tips and Tricks. I'll press OK, and this path gets added up here into my Trusted Location list. Then I'll come down and press OK here, and press OK once again to the Access Options screen. Now we won't be bothered with these warning messages every time we open up a new database.
If you don't add the Exercise Files folder to your Trusted Location, that's okay. Just be aware that you have to enable the content on each file as you open them, in order to get the expected results.
- Creating an AutoExec macro
- Creating a kiosk experience
- Working with hidden objects: queries, tables, and more
- Splitting a database into back and front ends
- Creating a dynamic reporting tool
- Adding shortcuts and other aids to end users
- Writing custom VBA functions
- Packaging and distributing your Access application