How to Add Simple User-Level Security to Microsoft Access Databases

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. https://599cd.com/Security

BECOME A MEMBER:
YouTube:    / @599cd  
or My Site: https://599cd.com/THMember

LEARN MORE:
https://599cd.com/UserLevelSecurity

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

FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: https://599cd.com/THFree
Blank Template: https://599cd.com/Blank
Contact Management: https://599cd.com/Contacts
Order Entry & Invoicing: https://599cd.com/Invoicing
More Access Templates: https://599cd.com/AccessTemplates

ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: https://599cd.com/Free1
How to Use Access in 30 Minutes: https://599cd.com/30Minutes
$1 Access Level 2: https://599cd.com/1Dollar
Donate to my Tip Jar: https://599cd.com/TipJar
Get on my Mailing List: https://599cd.com/YTML
Contact Me: https://599cd.com/Contact
TechHelp: https://599cd.com/TechHelp
Consulting Help: https://599cd.com/DevNet
Twitter:   / learningaccess  
https://en.wikipedia.org/wiki/Microso...
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft...

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

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.