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.

BECOME A MEMBER:

LEARN MORE:

PREREQUISITES:

LINKS:

RECOMMENDED COURSES:

NEXT VIDEO:

FREE TEMPLATE DOWNLOADS:

ADDITIONAL RESOURCES:

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.

[shahramahmadzadeh]

Hello Mr. Rost. I just wanted to say a big thank you to you for presenting this topic.
I have been waiting for this presentation for a long time.
I consider you my teacher, because I have learned a lot from you.
Unfortunately, I live in Iran and because of the embargo, I cannot buy your courses.
Once again, thank you for all your kindness and cares.

[rhodnill]

I did this thing to my project, but to make it more secure, I hashed(encrypt) the password and the Username so that "if" someone can bypass my database and get accessed to the UserT, the password and Username field is hashed or encrypt. I did the Hash password twice, there's a Level 1 Hash then Level 2 Hash.
Its like Password ⏩ Level 1 Hash ⏩ and the Level 1 Hash, Hash it again to Level 2 Hash and store it to the Password field in the UserT. just to make it secure. I also hashed the Username so that the bypasser have no Idea what is going on. 🤣🤣 But, thank you, my VBA code is more like a ancient text to read, so difficult to understand and it has more than 20 lines of code, unlike to your VBA Code is straightforward and easy to understand. 🤗😍 Can't wait for the Part 2 and 3. 🔥🥰

[thomascole]

Pure Gold! Great Instructor, easy to follow. Everytime I watch I learn another nugget I didnt know. Thank You

[TopGearEthiopia]

Hi Mr. Rost. Thanks for the training however, Please leave the password blank and see the result!

[onpassive]

You are a great trainer. I enjoy your lessons. I wish my English was better so I could join the group

[danielantoyma]

Hi Richard, thanks for your videos. I'm trying to find some info about SSO with Access. Would you know if it's possible? Thanks

[Dragon-vvew]

Hi Richard, your videos are always interesting, every time I see your videos I always learn some little properties to add to my little databases. Thanks again to you and your team! I'm sorry I don't know English but with subtitles you can understand perfectly.Many greetings from Italy!
Ciao Richard, sempre interessanti i tuoi video, ogni volta che vedo i tuoi video imparo sempre qualche piccola proprietà da aggiungere ai miei database. Grazie ancora a te al tuo team! Mi dispiace non sapere l'inglese ma con i sottotitoli si riesce a capire perfettamente. Tanti saluti dall'Italia

[RichardNickyBrian]

Thanks for this one too..
God bless your efforts.
Mr. Richard, live long and prosper. ❤🎉

[UltraStarWarsFanatic]

Richard, can you tie these accounts to the ability to enter design view/etc.? In the sense of having an account for developers, and another account for end users?

[meowmadecrafts]

I was literally about to implement something similar today! Thank you for sharing!

[abaurre]

I would like to implement this so I can do two things:
1- Open diferent forms or dashboards according to different users;
2- Use this user ID globally to register table changes and operations, by user.

Is it possible to carry on this "UserID" throughout other functions and subs, including private subs?

[andinascrocroandinas]

Hi Mr. Rost. One question.
the code correct is that:
If IsNull(TempVars("Username")) Then TempVars("Username") = "Nobody"
MainMenuLbl.Caption = TempVars("Username")

but if I have the second label that I want use in the same form, I just copy code? like that:
example
If IsNull(TempVars("Job")) Then TempVars("Job") = "Nobody"
JobLbl.Caption = TempVars("Job")

thanks

[muraterkan]

thank Richard. it very very useful and clean instructions.. as always

[MNAKSA]

Do you have any module to control data access like access security manager

[ADITYA_SINGH]

thanks for considering the request sir cant wait for part 3😃

[dolittlediehard]

Very good, love it but it would be better if users could set their own passwords and if the admin got an alert for 3 failed attempts.

[hosseinpeyvandi]

Nice and clean as always but how can i find part2??

[thunderkai]

Hello Mr Rost. Thank you so much for the tutorial. I want to ask that how do I add a "Hello" before the TempVars("Username")? Like I want to show "Hello XXX" in the main menu caption. Thank you.

[jamesrakestraw]

Hello. You make the Login. Do you need to make a Login log to?

[rbe]

Would it be a waste to pull, with an open recordset in vba, the record for the user and check for the id and password?