Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Posts
    5

    Unanswered: How to give different user types different permissions?

    I have two groups of users in a simple database with one table: regular users and admin.

    For admins, I want to be able to add, edit, delete records in the table.
    For regular users, I want the table to be read-only.

    What is the simplest way to do this? We don't want regular users to have to type in a password to be able to view the data.

  2. #2
    Join Date
    Oct 2003
    Location
    Roanoke, Va
    Posts
    445

    Smile Re: How to give different user types different permissions?

    Originally posted by ladybug
    I have two groups of users in a simple database with one table: regular users and admin.

    For admins, I want to be able to add, edit, delete records in the table.
    For regular users, I want the table to be read-only.

    What is the simplest way to do this? We don't want regular users to have to type in a password to be able to view the data.

    If you set up one group of read-only users, and just have one member

    of that group then they can all use the same UserName. Then, just set

    the password for the one user to blank. Hope this is what you're looking

    for.


    Gregg

  3. #3
    Join Date
    Oct 2003
    Posts
    5
    Thanks, that worked!

  4. #4
    Join Date
    Oct 2003
    Posts
    5
    Actually, that didn't quite work out...
    I did it through tools -> security in Access, but that only does it for the Microsoft Access on my computer. How would you get the DB itself to recognize what kind of user, or do you have to create a form and write some code?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •