Results 1 to 8 of 8
  1. #1
    3 Star Lounger
    Join Date
    Jul 2008
    Location
    Suffolk, United Kingdom
    Posts
    308
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How to create user level access (2003)

    Hi, how can I make my database require log-on and password details, and only allow access to certain areas and functions.

    Example:

    User Form Rights
    1 incomplete form read/edit/add/delete
    reports form read/edit/add/delete

    2 incompletes form read/edit
    reports form no access

    I also want to restrict viewing and editing the main navigation area (tables/forms/queries/modules etc) the source, sorry not sure what its called but the bit where you start creating your database. I want to restrict this to users who have access to view it.

    Many thanks.

    NB: If its possible to allow users access to somekind of control panel to change the password etc that would be a bonus. Thanks
    Regards
    Gerbil (AKA Kevin)

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

    Re: How to create user level access (2003)

    Access 2003 (and earlier versions) have the option to apply user-level security. It's a bit daunting in the beginning, but it's not too difficult.

    Microsoft's Microsoft Access Security FAQ is a good introduction. Our moderator WendellB has a short tutorial with useful links: The Secrets of Security.

    Just a warning: Microsoft is moving away from user-level security. It is not supported any more in the new .accdb database format introduced in Access 2007, so if you plan to upgrade to the .accdb format in the near future it may not be worth the effort to learn about it now.

  3. #3
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: How to create user level access (2003)

    Are they going to introduce another form of security?

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

    Re: How to create user level access (2003)

    No, they recommend that you move the data to SQL Server (with an Access frontend) if you need user-level security.

  5. #5
    4 Star Lounger
    Join Date
    May 2001
    Location
    Oxfordshire
    Posts
    456
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to create user level access (2003)

    Does this mean that creating a shared database ,in 2007, that's shared (using versions from 2002 onwards) has to have user level security set up in an earlier version? And would that actually work in 2007???? <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  6. #6
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: How to create user level access (2003)

    2007 still recognizes user level security for mdb files, but you can't use it for accdb files.
    If you are sharing with earlier versions of access then you must be using mdb.

    2007 allows you to set up security for mdb files as well.
    Regards
    John



  7. #7
    4 Star Lounger
    Join Date
    May 2001
    Location
    Oxfordshire
    Posts
    456
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to create user level access (2003)

    Cheers John.

    I have no experience with this (even in earlier versions), do you know where I can get instructions on how to accomplish this in 2007?

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

    Re: How to create user level access (2003)

    See Set or change Access 2003 user-level security in Access 2007.

    WendellB's tutorial The Secrets of Security provides an introduction and many useful links.

Posting Permissions

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