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

Поділитися
Вставка
  • Опубліковано 9 лис 2024

КОМЕНТАРІ • 14

  • @mamaducande2715
    @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 ?

  • @Jojosmith342
    @Jojosmith342 Рік тому

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

  • @PriestGx
    @PriestGx 3 місяці тому

    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  2 місяці тому

      599cd.com/Ask

  • @petewarby7158
    @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 😂

  • @shahramahmadzadeh5285
    @shahramahmadzadeh5285 Рік тому

    It was great, thank you sir

  • @restrepojorgea
    @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
      @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.

  • @iljak2914
    @iljak2914 Рік тому

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

  • @Hrubicundus
    @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
    @HusnaSadat-fo4zt 5 місяців тому

    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
    @dukestt5436 8 місяців тому

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