Results 1 to 13 of 13
  1. #1
    Lounger
    Join Date
    Aug 2001
    Location
    Lanham, Maryland
    Posts
    49
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Read Only Permissions (Access97)

    I have followed the necessary steps to secure my database. I want my
    database to be read only by anyone who opens it on the server (using
    the system.mdw so that they do not have to login). I logged into the
    database as the administrator after joining the proper workgroup file,
    and set the permissions for User group to read only. I then joined the
    system.mdw workgroup file and opened the secured database. When the
    secure database opened, the following error message was displayed:

    Error: 3033
    You don't have the necessary permissions to use the 'MSysDb' object.
    Have your system administrator or the person who created this object
    establish the appropriate permissions for you.

    I have gone through the security FAQs and have searched through this
    newsgroup for why this is happening, without success. I suspect I have
    incorrectly set the permissions for the User group or that my grasp of
    the Access security features is incorrect. Can anyone tell me the
    correct way to set permissions for the User group so that a user does
    not have to log in to view the data, forms and reports. TIA.

    Dick White

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Read Only Permissions (Access97)

    I'm not sure, but in your Permissions for the User Group, under Object type select Database, then make sure the Open/Run permission is checked.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Read Only Permissions (Access97)

    From your message, it appears that you are using two different workgroup files. If that's the case you are likely to get the error message you reported. It sounds like what you need to do is to remove the password from the Admin user account once you have secured it. But you need to make sure that you have another account that has full admin priviledges, and that Admin doesn't have any that you don't want normal users to have. You should also check the owner of the database and make sure that Admin is not the owner. Hope this helps.
    Wendell

  4. #4
    Lounger
    Join Date
    Aug 2001
    Location
    Lanham, Maryland
    Posts
    49
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Read Only Permissions (Access97)

    Thank you. I checked and the the User Group does have the Open/Run permission checked.

  5. #5
    Lounger
    Join Date
    Aug 2001
    Location
    Lanham, Maryland
    Posts
    49
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Read Only Permissions (Access97)

    I am using two workgroup files. One is with users who belong to the Admins group and have permissions to perform data entry and update. The other is the system.mdw file for people to view data and run reports. The database owner is not Admin. The intention is that general users will not have to login to view the data and run reports. I thought that would work if they were using the default system.mdw.

  6. #6
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Read Only Permissions (Access97)

    What you are describing should work. I assume the "standard" system.mdw file has the Admin user with a blank password, so anyone can log in? The secured database will immediately assign to the Users Group anyone that doesn't match it's permissions. The only other thing I can suggest is to go back and checkmark these permission boxes for all tables: Read Design, Read Data, Update Date, Insert Data, Delete Data.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  7. #7
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Read Only Permissions (Access97)

    In general using two different system.mdw files with a database (unless they are exact copies of each other - we do that so that the system.mdw file resides on the local hard drive of the workstation instead of the server) is fraught with difficulty. The problem is that the admin account is likely to have a different internal ID number, and when you secure a database using the wizard, that is always the case. The simpler solution is to use the same system.mdw file for all and create a command line interface that specifies the userID to log in with - it doesn't need to have a password. That way the general user never sees the login prompt.

    BTW, my previous advise may mislead you - you can't just remove the password from Admin and use that account for everyone, because then noone would get a login prompt, and you could never login as the users that need to update and enter data.
    Wendell

  8. #8
    Lounger
    Join Date
    Aug 2001
    Location
    Lanham, Maryland
    Posts
    49
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Read Only Permissions (Access97)

    Thanks. I hadn't thought about the different internal ID issue. I like your suggestion about the command line interface. Where is the best place to find information about Access97 command line switches?

  9. #9
    Lounger
    Join Date
    Aug 2001
    Location
    Lanham, Maryland
    Posts
    49
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Read Only Permissions (Access97)

    I wanted to prohibit general users from changing data in the database. If I set the permissions as you suggest, won't they then be able to do so?

  10. #10
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Read Only Permissions (Access97)

    You have to back-off on some permissions, but you still need the Read/Design and ReadData permissions.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  11. #11
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Read Only Permissions (Access97)

    Just do a help search on "command line" and it will give you all of the options. You can set the UserID, the Password, and the Workgroup file.
    Wendell

  12. #12
    Lounger
    Join Date
    Aug 2001
    Location
    Lanham, Maryland
    Posts
    49
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Read Only Permissions (Access97)

    Thanks. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  13. #13
    Lounger
    Join Date
    Aug 2001
    Location
    Lanham, Maryland
    Posts
    49
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Read Only Permissions (Access97)

    Thanks. <img src=/S/smile.gif border=0 alt=smile 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
  •