user/password problem

[Immanuel_Black]

Hello I am using the built in access user/groups to control access for my
access application. I have run into an issue with passwords. When I try and
read the password property of the user it says i can't change it to string.
Is there a reason for this or am I just trying to do it wrong. Here is the
code I am using:

 

[Immanuel_Black]

oops forgot the code. here is the code:


Dim wspWorkspace As Workspace
Dim usrUser As User


Set wspWorkspace = DBEngine(0)
strUserName = wspWorkspace.UserName
Set usrUser = wspWorkspace.Users(strUserName)

If (txtPassword <> usrUser.Password) Then
GoTo errWrongPassword
End If


it gives me an error at usrUser.Password

 

[Rick Brandt]

Hello I am using the built in access user/groups to control access
for my access application. I have run into an issue with passwords.
When I try and read the password property of the user it says i can't
change it to string. Is there a reason for this or am I just trying
to do it wrong. Here is the code I am using:

If VBA code could read a person's password that would make the password
pretty useless don't you think?

If you are using the built in user level security then it is ULS's job to
test passwords, not yours.

 

[Immanuel_Black]

Is there a way to get the ULS to verify the users password for my form. I'm
using it as a group management form. so the administrators can change the
user information within my application. I want some form of verification on
this form though. So I thought getting the admin user to enter their password
would be ideal

 

[Rick Brandt]

Is there a way to get the ULS to verify the users password for my
form. I'm using it as a group management form. so the administrators
can change the user information within my application. I want some
form of verification on this form though. So I thought getting the
admin user to enter their password would be ideal

Not sure I understand. If they attempt something that ULS indicates they
have no permissions to do then they will get an error. Isn't that
sufficient? For that matter you just give that group (only) permission to
your form so if they can successfully view the form you already know that
they have administrator rights.