Resetting AccessPwd in VBA

[SimonB]

I'm trying to set up a form for Admin staff which has a button to reset a user's password.

I know how to delete and recreate a user which could allow me to set the pwd as "" but can anyone suggest a more eligant method as I'm not sure whether my method would effect audit logs etc.

Cheers

 

[doulostheou]

Why don't you just put the user's password on the form (make it invisible if you don't want the admin to see it) and then onClick of the reset button write:

Password = ""
msgbox UserName & "'s password has been reset!"

 

[SimonB]

Thanks doulostheou,
Had a go but unable to place passwords on form, can you explain how.

Thanks again

 

[doulostheou]

Are you using user level security? If so, I unfortunately don't know how to access the passwords on a form. I have had the luxury of being able to avoid user level security. I've created my own password system for information that I want to be user sensitive but for the most part, my databases rely on NT logons for their security. If someone's NT logon allows them to access the supervisor's folder, they can view any of the supervisor databases.

[This message has been edited by doulostheou (edited 05-02-2002).]

 

[SimonB]

Problem solved (kind off). I've got a new and better job so the project is now on hold until I'm replaced.