471,579 Members | 1,985 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,579 software developers and data experts.

Changing Password using forms without userlevel security

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
0 1173

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

10 posts views Thread by Karl Burrows | last post: by
5 posts views Thread by John | last post: by
reply views Thread by XIAOLAOHU | last post: by
reply views Thread by Vinnie | last post: by
1 post views Thread by lumer26 | last post: by
reply views Thread by lumer26 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.