Jagwarman
asked on
Microsof Access Password[s]
we have an Access Database that uses a single password to get into the Db.
I need to change this so that each user [and we have 10] have their own passwords.
Now then, I am not an Access person but looking into the code I see this so, as a quick and dirty method would it be possible to just change the code to say: IF OR
the code is
word = Forms![*security].[passwor d]
If word = "xxxxxxx" Then 'password
passworde = True
DoCmd.Close
DoCmd.RunMacro "autoexec.procedures" 'optional procedures
Call hide_toolbars
Call UserInfoGather
Call LastUsed
Else
counter = counter + 1
If counter <> 3 Then
MsgBox "Incorrect Password Strike " & counter
Else
MsgBox "And Out"
DoCmd.Close
Exit Sub
End If
End If
Ideally I would like to do a proper job and have it so that each user would have a password linked to their PC signon which is in the tblUsers Table and make it so that they were forced to change password every x days, but I reckon that is a BIG job
Thanks in advance
I need to change this so that each user [and we have 10] have their own passwords.
Now then, I am not an Access person but looking into the code I see this so, as a quick and dirty method would it be possible to just change the code to say: IF OR
the code is
word = Forms![*security].[passwor
If word = "xxxxxxx" Then 'password
passworde = True
DoCmd.Close
DoCmd.RunMacro "autoexec.procedures" 'optional procedures
Call hide_toolbars
Call UserInfoGather
Call LastUsed
Else
counter = counter + 1
If counter <> 3 Then
MsgBox "Incorrect Password Strike " & counter
Else
MsgBox "And Out"
DoCmd.Close
Exit Sub
End If
End If
Ideally I would like to do a proper job and have it so that each user would have a password linked to their PC signon which is in the tblUsers Table and make it so that they were forced to change password every x days, but I reckon that is a BIG job
Thanks in advance
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What Access version? What back-end?
ASKER
Access 2010
What back-end?
what does that mean?
What back-end?
what does that mean?