From the course: Access 2016: Advanced Tips and Tricks
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Password-protect a back end
From the course: Access 2016: Advanced Tips and Tricks
Password-protect a back end
- [Voiceover] Now that our database is split into a front-end and a back-end, we might wanna take the additional step of password protecting our files to make sure that only authorized people can get in and make changes. Now, because of the way Access stores absolute file paths to the back-end database where our tables are stored, I can't actually distribute a starting exercise file. So, if you're following along, you'll need to continue on with the database that we split in the last movie. In order to password protect this front-end file, what I can do is come up to the File tab and choose this option here, Encrypt with Password. When I do, I'll get this dialogue box here that says that I must have the database open for exclusive use in order to set or remove a password. Go ahead and say OK to that, and I'll show you how to open up the database in exclusive view. First, we need to close the database down. So, I'm gonna go over here to the File tab, and choose Close. That'll exit out…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.