Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Australia
    Posts
    676
    Thanks
    28
    Thanked 2 Times in 2 Posts

    Security levels (Access 2007)

    Is there a way of allowing certain users to access some objects but not others (e.g., queries/forms/reports but not tables)?

  2. #2
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Australia
    Posts
    676
    Thanks
    28
    Thanked 2 Times in 2 Posts

    Re: Security levels (Access 2007)

    Thanks, Hans.

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Security levels (Access 2007)

    If you're using databases in Access 2000 or Access 2002/2003 format (*.mdb), you can apply user-level security. This lets you create users and groups, and assign different permissions for individual database objects to users and groups. See WendellB's tutorial The Secrets of Security.

    User-level security is not available in databases in Access 2007 format (*.accdb). See Set or change Access 2003 user-level security in Access 2007 for more info.

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Security levels (Access 2007)

    If you are using the 2007 .accdb format, we have some tools that might be of interest to you that do provide a form of user security for databases in that format. Post back if it is of interest to you.
    Wendell

Posting Permissions

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