Changing password in code

[harrisw]

I've created a form which lets a user change there own password in the database.

When it runs I get an error, I think the error relates to the users not having ADMIN rights to the database.

I've tried :

DBEngine(0).Users(txtUserName).Groups.Append ("supervisor")

but I get a compile error.

Is there a way that when the user clicks the update password button it temporarily assigns them admin rights and then removes them as the form closes.

 

[Autoeng]

Are you using Access security? If you are is the workgroup file in the same directory as the db? A compile error is not from insufficient rights but in a problem with the code. I posted last month code to change a users password if using Access security. I've had no problem and I don't think that the person who used the code had any either.

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=37534&highlight=password

Autoeng