How do you reference Users Access built-in security password?

[planetdrouin]

I have a form that allows users to change their own Access built-in security passwords using the code:

Set wsp = DBEngine.Workspaces(0)
wsp.Users(CurrentUser).NewPassword Nz(TxtOldPassword), Nz(TxtNewPassword)

However, I would like to add code upon startup which checks to make sure the users password (Access built-in security) is not null and if so open the change password form. How does one reference the users Access built-in security password?

Any help would be greatly appreciated.

Thanks

Lawrence

 

[hsitz]

I don't think you can reference the password at all, once it's entered.

But you may be able to accomplish what you want by checking the "Has password" attribute of the user's account. -- Herb

 

[hsitz]

On checking things, I don't see where to reference a "Has Password" attribute or property, although I see it referenced in Access Developer's Handbook. Help, anyone? -- Herb

 

[hsitz]

Lawrence -- sorry about any confusion I caused. The reference to a "Has password" property in ADH wasn't really what I thought it was. It was just part of a table comparing and contrasting characteristics of user accounts and group accounts.

So, at least as far as I can tell, there is no way to check what a user's password is _after_ it's created.

One solution to your dilemma might be to check what your users are trying to change their passwords to, _before_ they're created (or changed). So you could, for example, just set everyone up with the same new password, and then require all of them to establish new passwords. In the VBA procedure that handles this, you would check that [txtnewpassword] is not null before allowing them to set the password. -- Herb