user login form

[akshayjoshi222]

i have a table "pdp" containing fields-

EmpId,EmpName,EmpPass(i have provided passwords in this field)

i have a form "chng password" containing fields-

txtEmpPass,txtChngPass,txtConfPass

and a command button

i want user to input his existing password and new password and confirm password,on clicking the command button it should verify the txtEmpPass with EmpPass of table "pdp",if matches,then change it with the new password entered in txtChngPass

i have tried building a code.but not succesful. pls help

 

[ghudson]

Please search this forum for there are many posts related to your question.

FYI: Going this route will not prevent a user from linking to the tables in your database or prevent a user from importing all objects of your database into a new database.

 

[akshayjoshi222]

ok,thnks,i have corrected the code,and used update query to change the value