Results 1 to 4 of 4
  1. #1
    Join Date
    May 2009
    Posts
    30

    Unanswered: Database group permissions

    Having a problem with permissions again. Ive added another user to the admin rights group so they are equal to myself, but they are still unable to access certain parts of the database that is restricted to other users.
    Ive even manually gone into user access rights and given them full access to what they need, and they still can't access that part of the database.

    Anyone know whats going on?

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Remove them from the more restrictive groups... at a guess.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    May 2009
    Posts
    30
    Quote Originally Posted by StarTrekker
    Remove them from the more restrictive groups... at a guess.
    Users is a default group you cant remove any users from.

    Confused! Why cant it just work like it should !?

  4. #4
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    I would first try opening the mdb (on that users computer using the same shortcut they use) and enter the admin user/password which does work. (I'm assuming you're using an mdw security file with it being referenced in the shortcut to open the mdb.) If not, disregard this.

    If that works, I'd then try deleting and creating a new account in the mdw for that user with the appropriate permissions.

    If you are using an mdw for security, remember that the reference to the mdw file must be in the shortcut. It's possible the shortcut that user is using doesn't point to the correct mdw file (which should reside somewhere in the directory structure as the mdb file does.)

    Using MSAccess permissions (ie. an mdw file), the most common problem with permissions is the shortcut doesn't point to the correct mdw file.
    Last edited by pkstormy; 06-01-09 at 20:43.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

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