Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Feb 2001
    Location
    Wirral, Merseyside, Merseyside, England
    Posts
    88
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Password Protect a Form (Access 97/SR 2 )

    <img src=/S/help.gif border=0 alt=help width=23 height=15> I have a database that is totally restricted with all users accessing as the Admin user member of the Admins group which has been completely set up to have read only permission for all actions. I do not want to have all my users added into a workgroup as this will be too time consuming and difficult. So everone can log on but can do nothing damaging only view the data.

    I want to allow certain users Supervisor and Administrator members of the Supervisors and Administrators groups to be able to put a password on Admin, and then sign in using their ID and PW. These guys will be added to a workgroup.

    This is to be controlled by a password form, I will ask for their ID and PW check they are OK and bring up the change PW form, to set an admin PW. I can't seem to find any code that will allow me to authenticate the password.

    Any ideas or suggestions of a better way to do this?

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

    Re: Password Protect a Form (Access 97/SR 2 )

    I'm not clear on what you've done. Are you saying that the users are logging in as the Admin user with some kind of password or just opening the database and you've removed permissions from the Admin user? If they're logging on using Access security and with any kind of password, then they're already in a workgroup.

    I'd recommend that you read the Access security FAQ and the whitepapers available on the Microsoft site. Trying to mix workgroup security with something else is probably going to bite you sooner rather than later.
    Charlotte

  3. #3
    Star Lounger
    Join Date
    Feb 2001
    Location
    Wirral, Merseyside, Merseyside, England
    Posts
    88
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Password Protect a Form (Access 97/SR 2 )

    They are just opening the database and I've removed permissions from the Admin user?

    I would prefer a login box not to appear. If users are not in a workgroup then they access the database as the default user Admin and blank password.

    The Supervisor and Administration users have to be in a workgroup to get the extra functions. But as the Admin user can by default change a password without knowing the original, I want to ensure these guys are authenticated before I let them set a PW on admin.

    I have many users all over the place and I cannot control whether they will be set up in a workgroup or not, especially as most of them don't speak English.

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

    Re: Password Protect a Form (Access 97/SR 2 )

    I'm not entirely sure I follow you either. However, I'll take a stab at answering you - I have played around with letting people using the default workgroup do limited things without needing an id or password (note that everyone always uses a workgroup - it's just not obvious when the default one is in use) and requiring a specific workgroup (and an id and password valid in that workgroup) to do fancier stuff.

    The strategy is described in the MS white papers, so I won't detail. However, there's two possibilities in your questions that you're not distinguishing between:

    1) When your special users are using your special workgroup they have special privileges but those don't include being members of the Admins group. In that case, set the Admin password yourself and don't tell them what it is!
    2) When your special users are using your special workgroup they are members of the Admins group. In that case, you can't stop them from changing the Admin password (you can't stop them from changing any password), so don't fret about it - if you put someone in Admins then by definition you are trusting them to do anything they want to your database.

    Keep in mind that user ids (other than Admin which is a special case) are specific to the workgroup they are created in - your "Supervisor" and "Administrator" ids won't have any special privileges in the default workgroup (unless you created them there).

Posting Permissions

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