Access prevents new databases from running code or macros that it doesn’t trust. In order to have files work as intended, it’s important to add the location of the course’s exercise files to the Access Trust Center.
- [Instructor] Because Access will, by default, lock down new database files that it hasn't seen before, we'll need to add the exercise files for the course to a list of trusted locations, or we'll be plagued by this yellow security warning message every time we open up Access. So if you plan on following along with me, open up one of the databases, then come over here to the File tab and then come down to Options. Then we'll click on the Trust Center at the bottom of the list, and then click on the Trust Center Settings button on the right. From here we'll move up to Trusted Locations and then I'll come down and press the Add New Location button.
This will allow me to browse out to my computer where I saved the exercise files for the course. I placed them on my desktop in this file here. Let's go ahead and select the parent folder, and I'll press the OK button. And then I'll turn on this check box that says, subfolders of this location are also trusted. This'll make sure that all of the chapter folders are trusted as well. Let's go ahead and say OK to that, we'll say OK to that, and we'll say OK one more time. Now we can go ahead and close out of this database, and if I open it up again, you'll notice we no longer get that yellow bar. Now if you're using your own database files, then you can safely skip this step and get on with the course.
- Creating an AutoExec macro
- Working with hidden objects: queries, tables, and more
- Splitting a database into back and front ends
- Creating a dynamic reporting tool
- Helping end users by providing shortcuts and context-sensitive help
- Writing custom functions in Visual Basic
- Packaging and distributing your Access application