User Level Security Part 2: Control Which Forms & Reports Users Can Open in Microsoft Access

[@Jojosmith342]

All thumbs up to the most funny part of the tutorial "dont listent to people, i know what I am talking about" 🙂

[@petewarby7158]

UN.... believable.... Theres literally me and my wife going to use my database but i am going to use some of this security just because you've taught me how to do it! Spouse will role her eyes but what can I say. I'm a nerd in training 😂

[@vishy8397]

You are unparalleled

[@599CD]

Thanks. Better than being perpendicular!

[@PriestGx]

Hi Richard. This helped so much thank you. I followed your instructions to the dot, even made the tables and fields the same for the Users, but now, I do not need to type in a password to Logon... I only need to type the username and hit enter to enter the database. This is the same for all users in the UserT. What could the problem be?

[@599CD]

599cd.com/Ask

[@shahramahmadzadeh5285]

It was great, thank you sir

[@599CD]

Welcome

[@mamaducande2715]

Good evening, excellent video lessons, I liked it and it solved some problems I was encountering. Well, I would like to ask a question about MS Access and SQL-Server? The question is: How to protect the fields of database tables in SQL-Server and forms in Access, to allow edits and deletions only by the user creating this record in the database, and for others it will be just a read ?

[@iljak2914]

Thanks! 7:22 min about real world👍👍😂😂

[@599CD]

:)

[@restrepojorgea]

Great Video Richard !!!! Is it possible, instead of having a button that does not authorize a user, just make that that button does not appear. In other words, the Main Menu only displays the buttons for which the given user is authorized.

[@appleintosh]

Yes, it’s very similar to what he showed. In the form’s on-load event, you’ll check the removal, and set the buttons visible property to false if the user shouldn’t have access and true if they should have access.

[@Hrubicundus]

Amazing 👏. Is it possible to make it so if an unauthorised user tries to access a table or form they don't have access to, that the computer's speakers start outputting EXTREMELY LOUD embarrassing sex noises, so that everyone in the office immediately looks at them and the would be "hacker" quickly gives up and shuts it down?

[@HusnaSadat-fo4zt]

Please, can you teach me how to open the login form when I open the system, but when I enter my name and password, the form opens for me, but the system does not open, so please, can you teach me how to configure my login form automatically to open the system. Please do not open the form for me, I am waiting for your answer

[@dukestt5436]

If you dont want people to have access to things, don't show them the button in the first place