User Level Security Part 2: Control Which Forms & Reports Users Can Open in Microsoft Access
Vložit
- čas přidán 27. 07. 2024
- In this Microsoft Access tutorial I'm going to teach you how to control which forms and reports specific users can open in your database. This is a follow-up User Level Security Part 1 video.
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. 599cd.com/Security
BECOME A MEMBER:
CZcams: / @599cd
or My Site: 599cd.com/THMember
LEARN MORE:
599cd.com/UserLevelSecurity2
PREREQUISITES:
User Level Security Part 1: 599cd.com/UserLevelSecurity
RECOMMENDED COURSES:
Access Security Seminar: 599cd.com/Security
Access SQL Server Online: 599cd.com/SQLOnline
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Contacts
Order Entry & Invoicing: 599cd.com/Invoicing
More Access Templates: 599cd.com/AccessTemplates
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
How to Use Access in 30 Minutes: 599cd.com/30Minutes
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
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 to control what users have access to, Access Control Overview, Control user access to environments
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
All thumbs up to the most funny part of the tutorial "dont listent to people, i know what I am talking about" 🙂
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 😂
It was great, thank you sir
Welcome
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 ?
Thanks! 7:22 min about real world👍👍😂😂
:)
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.
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.
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?
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
If you dont want people to have access to things, don't show them the button in the first place