Solved Unable to successfully change user password on an access database form (1 Viewer)

[Tiprof]

i have a database which i wanted to update it with a password change form, which will enable users to be able to easily change the passwords after the default password has been set by the administrator.

I currently have a button that opens the password change form.

My issue is, if say I login as "Smith", and i click on the password change button, i should have "Smith" display by default on the user section of the password change form and any password i effect should update the current password for that current user in the table.

My current code isn't able to display the current logged in user on the password change form and also new password entered doesn't update in the table.

Any help with this will be greatly appreciated

 

[isladogs]

See my example app

Password Login

This utility has been provided to manage user passwords and also keep a user session log

www.isladogs.co.uk

 

[Tiprof]

See my example app

Password Login

This utility has been provided to manage user passwords and also keep a user session log

www.isladogs.co.uk

Have gone through your example. But am not able to understand it and apply to mine database. If you can do with the database i uplaoded here, i would be very grateful

 

[arnelgp]

i use Tempvars to save your user_name/user.

 

[Tiprof]

i use Tempvars to save your user_name/user.

Thanks for your response. I tried your database and the current user displays on the change password form.

but when I try to save the new password changes, it says “enter parameter value”

how can I fix that ?

 

[gemma-the-husky]

First, the name on the login form after the login is the user first name, rather than the the username. The first name is unlikely to be unique.
Then, in your password change form, you haven't set the username to any value - so what do you want this form to actually do?

 

[arnelgp]

i did not get that message.
in fact it did saved my changes.
did you first open the login form?

 

[lacampeona]

Hi Tiprof I try your database and you have some errors in your change password form.
Your change password form is copied from another internet page. I know it becouse I already see that and is the same problem. The password change form accept only numbers. If you write letters to change the password you wil get the “enter parameter value” box error.

I have some example from where you can learn a lot.

 

[arnelgp]

yes i saw what is wrong in the code.
here is the fix:

...
..
DoCmd.RunSQL "UPDATE tbl_login SET [Password]= '" & Me.txtPassword2 & "' WHERE [UserName]= '" & TempVars("user").Value & "';"
...

 

[lacampeona]

Yes
That is correct Arnel
very good.

 

[Tiprof]

Have taken a look at your suggestions and the database you guys checked for me and it worked perfectly.
I really appreciate all your efforts.

 

[Tiprof]

You guys are just amazing