User password change

[Beth]

I am looking for any help I can get with this problem. I have a front
end/back end setup on my Access 2002 database project. I am distributing
the application with Access Runtime, with as much security and disabling as
I can get my hands on. However, I need to allow users to change their
passwords on their own schedule instead of coming to me to help them with
it.
I created a form, frmChangePassword. The form has the following fields:
txtUser
txtOldPassword
txtNewPassword
txtConfirmPassword

There is one command button, cmdChange. I would like the user to enter
their information in these fields and then click the command button to
comfirm that the new password and confirm password are the same and then
change their password.

I have 3 problems. The first is that I can confirm the text of the 2 fields
is the same, but I don't know how to check the case.

Second, I am very inexperienced with VBA and I need to code change the
password based on the fields.

Finally, I also need the password changed on the backend datafile so that
the two files stay in sync.

I would appreciate any help you can provide on this.

Beth

 

[Beth]

I changed my search criteria and found some code to do the basic change,
(problem 2), but I still need help on the other 2 problems.

Beth

 

[TC]

For the case insensitive comparison, try:

strcomp (s1, s2, vbbinary) = 0

or somesuch. (I don't have Access here to check.)

If that doesn't work, just compare the numeric representations of each
character of the two strings:

(untested)

if len(s1) <> len(s2) then
msgbox "different lengths"
else
for n = 1 to len(s1)
if asc(mid$(s1,n,1)) <> asc(mid$(s2,n,1)) then
msgbox "different character(s) &/or case"
exit for
endif
next
endif

What do you mean by: "I also need the password changed on the backend
datafile so that the two files stay in sync"? If you're referring to
user-level passwords, those are stored in the workgroup information
file - not the FE or BE file.

HTH,
TC
(off soon for the day)

 

[Beth]

Thanks! The case comparison works and I needed reminding that the passwor
dwas in the workgroup file. I had forgotten.
Beth