Microsof Access Password[s]
Posted on 2014-08-05
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].[password]
If word = "xxxxxxx" Then 'password
passworde = True
DoCmd.RunMacro "autoexec.procedures" 'optional procedures
counter = counter + 1
If counter <> 3 Then
MsgBox "Incorrect Password Strike " & counter
MsgBox "And Out"
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