Password Expiration in Microsoft Access 97

[RobPotts]

Hi,

I would like to set password expiration up on my microsoft access database, has anybody got any tips or code on how to do this.

Cheers Rob

 

[Junior1544]

well, i'm working on the same thing... the first step i did was to create a form that the user has to use to change the password(i can provide a sample mdb in access 2000 if needed)... then i went to the code in the background and made it goto a table that records the user name and date that the password was changed. then you can check that table on load of the database. it's pretty simple once you get it going... I can help you through it if you want.

--James
junior1544@jmjpc.net
Life is change. To deny change is to deny life.

 

[Junior1544]

that is if you use access 2k

--James junior1544@jmjpc.net
Life is change. To deny change is to deny life.

 

[bosun]

I have built a prototype that I will be incorperating into my programs.

I have a user table which contains:
UserID
UserName
Password
PasswordDate

(For a little added security the user table is named MSysUsers. This effectively hides it from the average user.)

When a user logs in successfully a hidden form loads. Here is the code for that form.

Private Sub Form_Load()

If Date - PwdDate > 90 Then
MsgBox "your password has expired"
DoCmd.OpenForm "PwdChange"
DoCmd.Close
End If
End Sub

All you would need to add is a bit of code to close the form if the password is good.

Hope this helps. I love deadlines. I especially like the wooshing sound they make as they fly by.
-Douglas Adams