Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Nov 2003
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Security - Multi User (Access 2000)

    I have a database with many users. I have locked down the tables in the security settings (set the admin setting) to only adding data. I have a small group of people that need to make changes to the data (about once a month) but other than that the tables are locked down. Unfortunately, those that unlock the security settings to make changes forget to lock it back up then I have a mess and have to restore the whole thing, losing a lot of information and having to have them re enter data. Is there a way to have the tables locked down (by this, I mean only adding data, no changes or deletions allowed) every time someone opens the database. This should take care of the problem, as it would be "relocked" automatically. Any other suggestions would be great. I really don't want to set passwords or make users, as that is such a pain!!
    I am definately not an expert at this stuff... and can't write code, but have a little knowledge and am easily coached.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Security - Multi User (Access 2000)

    You are going about this the wrong way. Instead of changing the settings, you need to have different security permissions for different groups. Then have the users that need to edit the data log in as members of the group that has those permissions. Did you apply Access security and remove the permissions from the Admin user? Moderator <!profile=WendellB>WendellB<!/profile> has a security tutorial on his website at http://www.access-experts.com that might be of help to you.
    Charlotte

  3. #3
    New Lounger
    Join Date
    Nov 2003
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Security - Multi User (Access 2000)

    I never went through the wizard to do the security. Just set the user (admin) permissions. then when they needed to change the data, i had them change the permissions to administer. In the perfect world, they go back and change them back to "lock it down" but they are forgetting to do that, subsequently leaving it open and names and data is being changed all over the place (and whats worse is there is no real easy way to tell what/who)
    If you can do some hand holding, i would be thrilled to have some help and get this cleaned up.
    i always thought that the database defaulted to the administrator, so tahts why i did it this way.

  4. #4
    3 Star Lounger
    Join Date
    May 2002
    Location
    Toronto, Ontario, Canada
    Posts
    314
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Security - Multi User (Access 2000)

    It does default to Admin, but personally I think it's a BAD idea to have your users go in and change permissions themselves... It leads to...... well... exactly what's happening to you now... <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>

    Check out Wendell's tutorial that Charlotte mentioned... It's a great place to start... We can hold your hand as you have questions after that... <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  5. #5
    New Lounger
    Join Date
    Nov 2003
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Security - Multi User (Access 2000)

    Ok. I have read the part about security and am still lost. HELPPPPPPPPPPP
    I feel totally pathetic. I too think it is a bad idea, but you should have seen what we started with. <img src=/S/bif.gif border=0 alt=bif width=70 height=28>
    I can't figure out how to change to the user. i did set up a person (that will have admin permissions?) I really need some help here... <img src=/S/confused.gif border=0 alt=confused width=15 height=20> and <img src=/S/cooked.gif border=0 alt=cooked width=50 height=46>

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

    Re: Security - Multi User (Access 2000)

    I recommend that you download and study the Security FAQ from Microsoft. It is the first link in WendellB's tutorial, or go immediately to ACC2000: Microsoft Access Security FAQ Available in Download Center. It may take some time to digest, but it is a very useful and complete overview of user-level security.

Posting Permissions

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