Results 1 to 10 of 10
  1. #1
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Read only to Edit (Access 2000)

    A client wants to set a database up to be read only by default, with a button on the entry switchboard, for administration that once a password is entered they are able to edit it.
    How could this be done?

  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 to Edit (Access 2000)

    Hi Patt,

    Why don't you use User security ?
    For normal user you could add the username and password in the shortcut to start the database.
    For the administrator, use a different shortcut where the administrator has to supply the password.
    Francois

  3. #3
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Read only to Edit (Access 2000)

    Hi Francois
    Is there an easier way to do this?
    User security takes a while to setup.

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

    Re: Read only to Edit (Access 2000)

    You could use the on open events of the forms to check the password and according to that, set the Allow Edits, Allow Additions and Allow Deletions of the forms to true or false.
    But this will not prevent the user to go to the tables or queries and modify the data directly.
    Francois

  5. #5
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Read only to Edit (Access 2000)

    Thanks Francois, I was afraid of that.

    Well I may have to go into the deep end and research User Level security again.

    Can I setup this on a Access 2002 system then copy it to a Access 2000 system? Are there any curlies that I should be aware of? Or am I restricted to set it up on a Access 2000 system?

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

    Re: Read only to Edit (Access 2000)

    I have never worked on Access 2002.
    Recently I have to convert a secured Access 97 application to Access 2003. This has give me no problem, I still use the mdw file setup in 97. But it was upwards conversion. I have no experience with downwards conversion.
    Francois

  7. #7
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Read only to Edit (Access 2000)

    Any ideas on a good doco for User Level security?

  8. #8
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Read only to Edit (Access 2000)

    Pat,

    <!profile=WendellB>WendellB<!/profile> has a good security tutorial on his web site at http://www.access-experts.com. Just make sure the mdw file is in 2000 format and you should have no problems.
    Charlotte

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

    Re: Read only to Edit (Access 2000)

    Sorry for the late response, I'll had to go to a client site.
    The one I use a lot is :
    Microsoft Access Security FAQ Available in Download Center
    Francois

  10. #10
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Read only to Edit (Access 2000)

    Thanks Charlotte, I had already printed that one by the time you posted.

    Thanks Francois, I will also investigate that one.

Posting Permissions

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