Results 1 to 14 of 14
  1. #1
    Lounger
    Join Date
    Oct 2003
    Location
    Calgary, Alberta, Canada
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Read-only user access to Access Database (Access 97)

    Is there a way to designate a user having read-only access to a database? We have an in-house access database created to track Help Desk calls. A user has requested access to the application and we want to limit it to read-only access. Any assistance would be appreciated. Thanks much.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Read-only user access to Access Database (Access 97)

    Mary,
    You can make a database read-only in explorer but that make no sense because user can revert it and it is for all users.
    Take a look at <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=acc&Number=67507&page=2&vie w=collapsed&sb=5&o=0&fpart=all&vc=1>this thread</A>.
    You can also read <A target="_blank" HREF=http://support.microsoft.com/support/access/content/secfaq.asp>this article from MS</A>.
    Feel free to come back if something is not clear.

    Francois
    Francois

  3. #3
    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 user access to Access Database (Access 97)

    You would have to secure the database, which I'm assuming you have not done already. If you follow the Compuserve link below, then look for SECFAQ97.ZIP in the forum library, it explains how to do this.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

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

    Re: Read-only user access to Access Database (Access 97)

    Another thought (besides what the others have mentioned) - Does this person need the database to be up-to-the-minute current, or will a copy made e.g. once/day be satisfactory?

    That would remove the need to set up workgroup security, and you wouldn't even need to make sure the copy was read-only (if the user nukes it, then the user can wait until it is recopied).

  5. #5
    Lounger
    Join Date
    Oct 2003
    Location
    Calgary, Alberta, Canada
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Read-only user access to Access Database (Access 97)

    I suspect they want access to the current database - therefore a copy wouldn't be acceptable. I think we need to set up the workgroup security.
    Thanks anyway.

  6. #6
    Lounger
    Join Date
    Oct 2003
    Location
    Calgary, Alberta, Canada
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Read-only user access to Access Database (Access 97)

    Brand new site to me. How do I find the zip file? I've clicked on every search item I can find.
    Thanks

  7. #7
    Lounger
    Join Date
    Oct 2003
    Location
    Calgary, Alberta, Canada
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Read-only user access to Access Database (Access 97)

    Thanks. I'm reading through the stuff now. I thought we might have to revise the database. It was inherited and hasn't been updated in quite some time. As the intent is to replace it with SQL, I was hoping I wouldn't have to mess with much.

  8. #8
    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 user access to Access Database (Access 97)

    When you enter the forum, you should see 2 arrows on left upper part of screen, labeled "messages" and "Files". Click on the File arrow, then when search window appears, just enter security. I noticed one of the first entries was Security FAQ for Access2000.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

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

    Re: Read-only user access to Access Database (Access 97)

    If your move to SQL in imminent, you can use SQL security to prevent users from editing the data in that fashion, but you probably don't want users modifying forms, queries, etc., so Access security is in order. There is a wizard that will step you though it and makes it pretty painless, although maintenance of the system.mdw file used to store user names can be a pain. If you have lots of user who should be read-only, you might consider having them all use the same Access login name.
    Wendell

  10. #10
    melhado
    Guest

    Re: Read-only user access to Access Database (Access 97)

    Reading through this and the ones for 2K, does this apply to split databases, where one wants to lock down the back end tables and allow only certain permissions on different front ends?

    There doesn't seem to be any mention of this kind of security. How does it differ? Or is it just a matter of using network security to lock down the back end, and treat the front ends as the security for that user?

    thanks

    'dave

  11. #11
    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 user access to Access Database (Access 97)

    Quite frankly, I'm lousy at security, which is why I pointed you to those FAQs. Maybe someone else can help you on this.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  12. #12
    melhado
    Guest

    Re: Read-only user access to Access Database (Access 97)

    That's funny <img src=/S/rofl.gif border=0 alt=rofl width=15 height=15> I posted hoping that someone could feedback.

    I have done one-piece databases, but never a split one requiring many different kinds of permissions. Being a split database, I am not certain if both ends need securing.

    Meanwhile, Mark, whatever you may lack in Security, you more than make up for in Subforms navigation, which leads me to ask {smooth segue} if you happen to have looked at my posting on <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=acc&Number=69464&Search =true&Forum=acc&Words=69464&Match=MessNum&Searchpa ge=0&Limit=25&Old=allposts&Main=68552>finding a record in the subform and returning the mainform</A>? Pardon the off-topic segue, but I am stumped, and could use your insight.

    thanks

    'dave

  13. #13
    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 user access to Access Database (Access 97)

    >>I have done one-piece databases, but never a split one requiring many different kinds of permissions. Being a split database, I am not certain if both ends need securing.<<

    Well, I do know they both need securing, it just depends on how much. You might be able to get by with a database password on backend, but I don't really know for sure.

    --------------------

    >>Meanwhile, Mark, whatever you may lack in Security, you more than make up for in Subforms navigation, which leads me to ask {smooth segue} if you happen to have looked at my posting on finding a record in the subform and returning the mainform? Pardon the off-topic segue, but I am stumped, and could use your insight.<<

    I found it, but had noticed Charlotte had responded. I'll give it another looksee.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  14. #14
    New Lounger
    Join Date
    May 2002
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Read-only user access to Access Database (Access 97)

    One alternative is to setup Access security on the database and give userids/passwords to users who will be updating the data. Set security permissions for the default "Admin" user in the database to readonly for all of the tables in the database, and set the password to blank. Then you can let anybody read the data without having to login, and with no access to modify anything. You don't even have to have the correct mdw file referenced for it to work OK for the ordinary users.

    You need security on whatever you don't want the users to modify. If that is the only the data, then you can get by with setting security only on it. If you don't want them messing with the front-end database, then you have to have security on it also.

    If you use this technique, you must include /user on the command line for the personnel authorized to modify data, because Access will not automatically ask them to logon with a blank password for the Admin user.

    There is a Microsoft Whitepaper on setting security using this technique. I've been using it several databases with good success.

Posting Permissions

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