By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
460,022 Members | 1,372 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 460,022 IT Pros & Developers. It's quick & easy.

Changing Password using forms without userlevel security

P: n/a
hi all,

i am doing a project which requires me to provide a security login
feature.
i understand that access has a user level security feature but i could
not use it coz i'm tested on my ability to use existing controls.

i did the login form, then it occured to me that it would be much more
convenient for users to change passwords themselves without needing the
administrator to change for them.

So, i created another form containing the following:

txtusername
txtOldPw
txtNewPw
txtconfirmPw

and a command button, cmdChangePW

on the click event of the command button, i ran a macro which did the
following:

1) check textboxes are null
2) check passwords are correct
3) run 3 SQLs

SQLs are like this [Do note that there are 3 tables containing 3
different userIDs and passwords to provide for different permissions
for different users]

UPDATE tblPasswordReceivi
SET tblPasswordReceivi.Password = '" & txtConfirmPW & "' WHERE
tblPasswordReceivi.UserID ='" & txtusername & "'";

UPDATE tblPasswordPurchase
SET tblPasswordPurchase.Password='" & txtConfirmPW & "' WHERE
tblPasswordPurchase.UserID ='" & txtusername & "'";

UPDATE tblPasswordMgmt
SET tblPasswordMgmt.Password='" & txtConfirmPW & "' WHERE
tblPasswordMgmt.UserID ='" & txtusername & "'";

---------------------------------------------------------------------------------------------------------------------------------------

the problem i have is that the new password does not update itself to
the respective table..is something wrong here? i am still a newbie with
access (i just learned it at the end of last year), and realli not very
sure how to do modules esp. Can i do without modules and just stick
with macros?

To all ya kind souls, i thank you..i realli appreciate it!

Jan 13 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.