Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Mar 2002
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    multiple user security (Access 2000)

    How do i set up multiple user security, each with a different password and logon? Can multiple people open up the database and save changes, if they are given that privilege? I played around with trying to set this up but may not be going around the procedures correctly. Do i set up groups first? Not sure. Thanks.

  2. #2
    New Lounger
    Join Date
    Mar 2002
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: multiple user security (Access 2000)

    I hope that help u .
    Ashraf
    Attached Files Attached Files

  3. #3
    New Lounger
    Join Date
    Mar 2002
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: multiple user security (Access 2000)

    Great! But how do I implement this in my database? I assume this would be in the database that I'm using, but does it work in a sense that access to all objects in the database are not accessible until the user logs on? Maybe i've got this going all in the wrong direction. Would i set the logon to appear in the switchboard? Thanks!
    -Youa

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

    Re: multiple user security (Access 2000)

    The sample that was posted is after the fact security and is fairly easy to bypass. Why not use the built-in security features of Access? That will force the user to login before they can even open the database.

    You can get a start on that by going to Tools-->Security and choosing User Level Security Wizard, which will walk you through creating a workgroup and setting up Access security on a database. Make sure you create a new workgroup file, since you don't want to have security pop up on all your databases, just this one. The Help button on the wizard will take you directly to the Help articles that deal with organizing security accounts and creating users, groups, etc.
    Charlotte

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

    Re: multiple user security (Access 2000)

    Have a look at Frequently Asked Questions About Microsoft Access Security for Microsoft Access versions 2.0 through 2000
    It's a good starting point to implement User security
    Francois

Posting Permissions

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