From the course: Access 2016: Forms and Reports

Add exercise files to a trusted location

From the course: Access 2016: Forms and Reports

Start my 1-month free trial

Add exercise files to a trusted location

“

- [Voiceover] Access databases can contain macros and Visual Basic code that is typically needed to ensure that the database functions as intended. This code is written in the Visual Basic programming language and it's possible, though rare, that the code in an Access database can contain malicious routines. Because of this, Microsoft requires that you specifically white-list each and every database file that you start up. You'll see this presented every time you open an exercise file by this yellow bar across the top of the screen. You can press the Enable Content button to trust that single file, but you'll have to do this for every file that we open. Rather than do that for each and every one of the databases that we'll use throughout this course, I'd like to make one small change to the program settings which will grant the required permissions to all of our exercise files at once. To do this, we'll come over here to the File tab, and then we'll come down to Options. In the Access Options window, we're going to find the Trust Center setting here at the bottom, then come over to the far right and press Trust Center Settings. On the Trust Center Settings window, we're going to come up here to the top and press Trusted Locations, and then come down here to the bottom and add a new location. I'm going to press the Browse button here and browse onto my Desktop which is where I've stored the exercise files for me. Go ahead and scroll down here and select the Exercise Files folder and press OK. Then, make sure you check this box here that says Subfolders of this location are also trusted. This way all of the files within the chapter folders are also trusted. I'm going to add a description here to remind myself of why I'm adding this trusted location, and I'll just called Access 2016: Forms and Reports in Depth. Go ahead and press OK, and OK again, and OK one more time. So now that our exercise databases are trusted by Access, we can get to the business of exploring forms and reports without the constant interruption.

Contents