SECURITY and passwrd change

[Jacinto Muchine]

Hi Everyone,

I have created an Access Database and have the User-level
security working.

Is there a way I can create a simpler, more user-friendly
inputboxes that allow users to change their passwords
given their current login details, Instead of using the
ordinary, Tools|Security|User and Group accounts?

Thanks for your help!!!

Jacinto

 

[Jacinto Muchine]

Thanks Graham for both your replies, very helpful!!!

However, I could not see the attached file mentioned in
this reply.

Thanks,

Jacinto

-----Original Message-----
Hi Jacinto,

Set up a form with three textboxes for old pwd, new pwd and verify. It's
then an easy matter to change the password with:
DBEngine(0).Users(CurrentUser()).NewPassword sOldPwd, sNewPwd

I've attached a textfile containing the definition for such a form, complete
with code. You can load it by saving it to your HDD and typing this in the
debug window:
LoadFromText acForm, "dlgChangePassword", "<path to file>"

Then, your click event simply needs to open the form:
DoCmd.OpenForm "dlgChangePassword", WindowMode:=acDialog

--
Good Luck!
Graham Mandeno [Access MVP]
Auckland, New Zealand

Return mail address is invalid in a vain attempt to reduce spam.
Feedback is welcome at: (e-mail address removed)
Please post new questions or followups to newsgroup.

Hi Everyone,

I have created an Access Database and have the User- level
security working.

Is there a way I can create a simpler, more user- friendly
inputboxes that allow users to change their passwords
given their current login details, Instead of using the
ordinary, Tools|Security|User and Group accounts?

Thanks for your help!!!

Jacinto

 

[Graham Mandeno]

Hi Jacinto

That's strange - I can see it on my news server. I'll email it to you at
your hotmail address below. If you don't get it, drop me an email.

--
Good Luck!
Graham Mandeno [Access MVP]
Auckland, New Zealand

Return mail address is invalid in a vain attempt to reduce spam.
Feedback is welcome at: (e-mail address removed)
Please post new questions or followups to newsgroup.

news:[email protected]...