Prompting Users for a new password

[Secret Squirrel]

Ok, I've successfully created the security part of my database now I have two
final questions...

1. How do I get users to create their own password when they access the
database for the first time?

2. Can I have it set up so that the passwords expire after a certain amount
of time?

 

[Rick B]

Both of these questions are asked and answered pretty often. I have seen
several responses that include sample code and the layout for the tables
needed to accomplish this.

Do a search and read the previous posts out there.

 

[Troy W.]

Have never tried this before personally, but just running it through my
head....Create a table with two fields. The user name and then the password
date. When they first enter the database, have access look at the table,
find their user name and compare the password date with the current date. If
it has expired, pop up a form that lets them change the password and lock the
form until they actually do change it. If you want to force them the change
it for the first time, just go in and set the date to sometime last year.

Troy

 

[Secret Squirrel]

I wouldn't know where to begin with this. Any help would be greatly
appreciated.

 

[TC]

That's not quite enough. It won't see the case where the user changes
his password before the last-chance date. When he does that, the
checking period should start again. You can do this by saving his
encrypted password (which you can get by opening the workroup file as a
database). Then check on each open, to see it he's changed it.

HTH,
TC

 

[Secret Squirrel]

Can you give me an idea of how to set this up? I'm sort of new at this. Thanks

 

[Troy W.]

Unfortunately I don't have my program in front of me with the code to change
the passwords programicly but you can find at
http://support.microsoft.com/default.aspx?scid=kb;en-us;200665. But here is
just the steps you will want to take...

-When your program loads, have it retrieve the current password experation
date and compare it to the current date.
-If the date has passed, show a form with a text box where they can enter
the new password.
-The form sets the password (note:for this to work, there has to be an old
password. If not previous password has been set, it will give you an error).
-At the same time that you change the password, set the experation date to
whatever the new date should be.
-In order to force your users to use this interface as opposed to just using
the regular menus, I always set the security features to hide the menu bars.

Troy