Link to home
Start Free TrialLog in
Avatar of Jagwarman
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].[password]
   
    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
Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
What Access version? What back-end?
Avatar of Jagwarman
Jagwarman

ASKER

Access 2010

What back-end?
 what does that mean?
Where do you store your data?

See also Split an Access database.
Note too that Peter's Software has a nice utility for this:

http://www.peterssoftware.com/las.htm