Add New User - Password

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I am now in charge of a database that has many users who all log on with a
password. I have never used security or had a database with multiple users
before. I am able to go to Tools, Security, Users and Accounts and add a new
User and then make them part of the Groups that I need to, but I don't know
how to set up a password for a new user? Help!

thanks in advance,
Janet
 
You can't, via the dialog.

You can:

Log in as that user and go to Tools, Security, Accounts, Password tab and
set it.
or
Create the user/password using code
or
Leave it blank, and provide a form for the user to set their own password.
You could even test for a blank password and then bring up the form for them
to set one.
or
....
 
Dear Joan:

If I prefer the third method you provided. Do I have reference that I can
find?
Also is this option allow the user to change it's own password?

Thanks.

Vivi
 
If you search at Google groups you'll find lots of examples and code.

http://groups.google.com/groups?as_...as_maxd=23&as_maxm=2&as_maxy=2006&safe=offYou create a form with textboxes to capture the old and new passwords.Using VBA code, you can validate that the old password matches the existingone, and then change the password to the new one.There's sample code in the Security FAQ as well. http://support.microsoft.com/support/access/content/secfaq.asp--Joan WildMicrosoft Access MVPVivi wrote:> Dear Joan:>> If I prefer the third method you provided. Do I have reference that> I can find?> Also is this option allow the user to change it's own password?>> Thanks.>> Vivi>> "Joan Wild" wrote:>>> You can't, via the dialog.>>>> You can:>>>> Log in as that user and go to Tools, Security, Accounts, Password>> tab and set it.>> or>> Create the user/password using code>> or>> Leave it blank, and provide a form for the user to set their own>> password. You could even test for a blank password and then bring up>> the form for them to set one.>> or>> ....>>>>>> -->> Joan Wild>> Microsoft Access MVP>>>> JanetF wrote:>>> Hello,>>>>>> I am now in charge of a database that has many users who all log on>>> with a password. I have never used security or had a database with>>> multiple users before. I am able to go to Tools, Security, Users>>> and Accounts and add a new User and then make them part of the>>> Groups that I need to, but I don't know how to set up a password>>> for a new user? Help!>>>>>> thanks in advance,>>> Janet
 
Back
Top