Password

[Kevin S.]

How can I retrieve the password for the current user or another user in
Access 2002? I've tried dao.workspaces(0).users(currentuser()).password but
all I get is error messages. However, I can get change password to work.

This will be used to confirm someone's identity quickly within the database
before certain changes are made.

Thanks for any help
-Kevin

 

[Rick Brandt]

How can I retrieve the password for the current user or another user in
Access 2002? I've tried dao.workspaces(0).users(currentuser()).password but
all I get is error messages. However, I can get change password to work.

This will be used to confirm someone's identity quickly within the database
before certain changes are made.

Umm, just how useful would a password be if it could be retrieved with a few
lines of code?

You can use CurrentUser() to get their UserName, but that's it. Allowing an
Admin the ability to set or clear a password is not the same as letting them see
what it is after it is set.

 

[Kevin S.]

You have a really good point there... but hey, its Microsoft... there is
always a way ;-).

 

[TC]

You can confirm that someone's password is correct >without< knowing what
that password actually is! This is basic "Crypto 101". >No< password
confirmation method in >any< computing environment should >ever< actually
reveal the passwords.

In Access, just use the CreateWorkspace method to create a temporary
workspace with any username & password. If that >works<, the specified
username/password combination is correct. If it >doesn't< (which you can
trap with standard error handling), the specified username and/or password
is not correct.

HTH,
TC