Results 1 to 6 of 6
  1. #1
    Star Lounger
    Join Date
    Feb 2001
    Location
    South Carolina, USA
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Security AGAIN!! (Access 97/sr2)

    It has been several months since I have worked with security and I am stuck!!

    I have create a new workgroup file, added a password for admin, create a DEVELOPER user and gave all admin rights to the developer. Ran the wizard. I have created all my users and groups and assigned permissions. Now this is where I am stuck.

    When I log on as developer - great but when I try to log on as a restricted user - I get an error message that I don't have permission to use the database.

    What's missing? Is it just Friday 13th????

    Deborah

  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 AGAIN!! (Access 97/sr2)

    Check your user permissions and see what you gave them. It sounds like they don't have any permissions for your database. If they can get in but can't see or do anything, you need to give them at least read permissions. Depending on how your forms, etc., are built, they may need more. Check your queries as well. If you set their run permissions to run with user's permissions, then change them to owner's.
    Charlotte

  3. #3
    Star Lounger
    Join Date
    Feb 2001
    Location
    South Carolina, USA
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Security AGAIN!! (Access 97/sr2)

    Charlotte,

    I have assign more than read permissions to everything. The data entry people can not print reports so I did not change anything there.

    When I double click on the icon and log in as a data entry person, I get the error message then.

    I am unsure about changing the ownership. Can you explain that again. I have my Developer user with admin rights and it seems to have all the rights to every option. I have a user for Directors who can print and enter data and data entry group who can only enter data.

    I have deleted the secure file and the .mdw file and started over but still no luck. I don't understand. I do have a lot of vb attached to my reports. Would this be causing problems?

    Thanks,
    Deborah

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

    Re: Security AGAIN!! (Access 97/sr2)

    Just to elaborate on Charlotte's answer (only because setting the rights to the database itself confused me way back when I was first playing with securing databases), go to Tools | Security | User and Group Permissions and scroll the Object type right back to the very first option, which is Database, and check the permissions there. Took me a while way back when to notice that I could scroll the Object type back before Table.

  5. #5
    Star Lounger
    Join Date
    Feb 2001
    Location
    South Carolina, USA
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re:THANKS!!! Security AGAIN!! (Access 97/sr2)

    That was my problem....is that a bug, that it does not immediately go to the database instead of the table.

    Thanks for your help!!! I really thought I was going crazy.

    Deborah

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

    Re:THANKS!!! Security AGAIN!! (Access 97/sr2)

    The fact that it goes to "Table" isn't a bug; actually, it goes to whatever type of object you were looking at before going into Security - try looking at your forms and then going into Security.

    The fact that you never see "Database" until you realize that there's a scrollbar there I would consider rather quirky. <img src=/S/aflame.gif border=0 alt=aflame width=15 height=15>

Posting Permissions

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