Changing Passwords in an MDE

[hilbertl3]

Is it possible to have a user change his/her password through vba in an mde file? I have some code set you to change a password through vba in an mdb file, but the same code won't execute in an mde. When the code runs in the mde Access crashes.

Hilbertl

 

[JerryKlmns]

Does this line of code run Ok?

CurrentProjectConnecion.Execute "ALTER USER " & CurrentUser & " PASSWORD " & Me.txtPswrd & " " & Me.txtNewPswrd

assuming that in a form you do have a textbox for old password and for the new one.

 

[hilbertl3]

This works in a way...
I seem to be able to change other user's passwords but not my password. That is, I logged in as the administrator and then executed the code the change my user's password but I got an error saying that I had no permissions to change object ''.

In any case, last night I recompiled the mdb file and created and mde and the password code that had previously been giving me an error in the mde file worked just fine. I guess maybe the first mde was somehow corrupt.

hilbertl