User Level Security in Microsoft Access, Part 1

In this Microsoft Access tutorial I will teach you how to add simple user-level security to your databases. We will create a user table and give each user a logon name and password.

Disclaimer

This tutorial will show you security that is "good enough" to keep most users out of your database. However an experienced Access developer will be able to bypass this logon routine. To learn the best possible way to secure your database I recommend my Microsoft Access Security Seminar. 

• Access Security Seminar: https://599cd.com/Security

Members

There is no extended cut, but here is the database file:

•  Database Download - Gold Members

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Prerequisites

• Intro to VBA: https://599cd.com/IntroVBA
• Modal & Popup: https://599cd.com/ModalPopup
• DLookup: https://599cd.com/DLookup
• NZ Function: https://599cd.com/NZ
• If Then: https://599cd.com/IfThen
• MsgBox: https://599cd.com/MsgBox
• Simple Security: https://599cd.com/SimpleSecurity

Links

• Input Mask: https://599cd.com/InputMask
• Double Double Quotes: https://599cd.com/DoubleDouble
• Track Log On: https://599cd.com/TrackLogon
• Database Password: https://599cd.com/DatabasePassword

Recommended Courses

• Access Security Seminar: https://599cd.com/Security
• Access SQL Server Online: https://599cd.com/SQLOnline

Next Video

• User Level Security Part 2: https://599cd.com/UserLevelSecurity2

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 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

access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, How do I set up security, What happened to user-level security, securing a Microsoft Access database, How To Manage User Permissions In Access Database, user table, usert, username, password