Results 1 to 6 of 6
  1. #1
    penn
    Guest

    Access 2000 Database Permissions

    <img src=/S/weep.gif border=0 alt=weep width=21 height=16>Please, I am confused. I've just put my Access 2000 database up over the network - NT4. I have set the permissions of the tables so that there are some tables and forms which only one group have any permissions for the rest of the users - in a different group dont have any access to these. I put the database up and connected to the workgroup via the shorcut. However when anyone of the users who should not have any permissions for these forms opens the database the permissions of the database file on the network changes and adds that person and gives them full control, giving them access to the tables and forms which they shouldn't have any access to.

    TIA

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Edmonton, Alberta, Canada
    Posts
    326
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access 2000 Database Permissions

    Have you removed all permissions from the default Admin user and ensured that that user is no longer in the Admins group?

  3. #3
    penn
    Guest

    Re: Access 2000 Database Permissions

    Yep, So not sure whats going on. Or if it is an access problem or an NT one!
    Cheers

  4. #4
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Goose Creek, South Carolina, USA
    Posts
    108
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Re: Access 2000 Database Permissions

    Your problem MAY lie in the 'Users' group permissions, which is a default group from which individual users can't be removed. I remove all permissions from the Users group.
    Once the default Users group have no rights to anything, create a new group(s) that have the appropriate rights and assign users to these groups as appropriate.

    As the previous responder stated, it is also necessary to remove Admin from the Admins group.

  5. #5
    penn
    Guest

    Re: Access 2000 Database Permissions

    Thanks, I'll do all and have another test. <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  6. #6
    penn
    Guest

    Re: Access 2000 Database Permissions

    FANTASTIC, thank you very much. I didn't know that users gave full permissions to everybody on everything. It is now behaving as a good database should. <img src=/S/groovin.gif border=0 alt=groovin width=21 height=21> <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

Posting Permissions

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