Prompting Users for a new password

29 Oct 2005 9:52 PM

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?

31 Oct 2005 8:43 PM

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.

--
Rick B

Show quoteHide quote

"Secret Squirrel" <secretsquir***@discussions.microsoft.com> wrote in
message news:0EA58E96-2233-4FB9-846F-780B8ECC3049@microsoft.com...
> 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?

31 Oct 2005 9:13 PM

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

Show quoteHide quote

"Secret Squirrel" wrote:

> 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?

31 Oct 2005 11:45 PM

Secret Squirrel

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

Show quoteHide quote

"Troy W." wrote:

> 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" wrote:
>
> > 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?

1 Nov 2005 1:25 PM

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
Show quoteHide quote

"Secret Squirrel" wrote:

> I wouldn't know where to begin with this. Any help would be greatly
> appreciated.
>
> "Troy W." wrote:
>
> > 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" wrote:
> >
> > > 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?

31 Oct 2005 11:57 PM

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

1 Nov 2005 1:19 AM

Secret Squirrel

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

Show quoteHide quote

"TC" wrote:

> 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
>
>