Force Users to change their Passwords every 90 days

[Hank]

I have requirement for an Access 2002 database application were the users
passwords must be changed every 90 days. How can I keep a timestamp of when
each user changed their password last so that when the 90 days has elapsed I
can automatically have the change password window pop up? I’ve looked at my
System.mdw file and noticed the query MsysUserList lists the current users.
I guess the underlying table is encrypted so there’s no way for me to add a
field with the timestamp, right? Any help would be appreciated (e.g.
examples, code, reference material, etc.).

 

[Rick B]

There are several previous posts on this topic. Did you do a search?

Check out the following posts. There are a few promising ones on the second
page...


http://groups-beta.google.com/groups?q=microsoft.public.access+force+password+change&start=10&hl=en&

 

[Hank]

Rick,

Thanks for the help. I found a step by step procedure on page 3 of that
link you gave me:

http://groups-beta.google.com/group...assword+change&rnum=30&hl=en#d6538a777f310567

However I'm not sure how to go about adding all users in the table
"expirationdate" (i.e. step #2)? Also how do you maintain this table as
users are added and deleted?

Thank You.