|
Home > Archive > MS Access Multiuser > August 2005 > Prompt to change password in Access
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Prompt to change password in Access
|
|
| Lisheen 2005-08-24, 9:24 am |
|
I was wondering if someone could tell me if it is possible to set MS
Access to prompt or force a user to change his password every 90 days.
I dont think it is possible using MS Access security but would it be
possible if I set up my own security.
I had thought of doing this by using a form into which a user enters
his password which is then compared to the users password held in a
table if they match the switchboard form is opened, this works but I
still need to find a way of forcing the user to change his password
every 90 days.
If there is a way of doing this using MS Security I will gladly use
this instead.
Your help is appreciated.
Rgds
Nora.
--
Lisheen
------------------------------------------------------------------------
Lisheen's Profile: http://www.officehelp.in/member.php?userid=510
View this thread: http://www.officehelp.in/showthread.php?t=751489
Visit - http://www.officehelp.in | http://www.officehelp.in/archive/index.php | http://www.officehelp.in/index/index.php
| |
| Rick B 2005-08-24, 9:24 am |
| This is not possible in Access Security.
Creating your own would greatly reduce the security of your database. Read
the hundreds of previous posts on growing your own security for more
details. What you gain in security by making them change their passwords
would be lost by the risk of them reading your password table.
--
Rick B
"Lisheen" <Lisheen.1u9ruh@NoSpamPleaze.com> wrote in message
news:Lisheen.1u9ruh@NoSpamPleaze.com...
>
> I was wondering if someone could tell me if it is possible to set MS
> Access to prompt or force a user to change his password every 90 days.
> I dont think it is possible using MS Access security but would it be
> possible if I set up my own security.
>
> I had thought of doing this by using a form into which a user enters
> his password which is then compared to the users password held in a
> table if they match the switchboard form is opened, this works but I
> still need to find a way of forcing the user to change his password
> every 90 days.
>
> If there is a way of doing this using MS Security I will gladly use
> this instead.
>
> Your help is appreciated.
>
> Rgds
>
> Nora.
>
>
> --
> Lisheen
> ------------------------------------------------------------------------
> Lisheen's Profile: http://www.officehelp.in/member.php?userid=510
> View this thread: http://www.officehelp.in/showthread.php?t=751489
> Visit - http://www.officehelp.in |
http://www.officehelp.in/archive/index.php |
http://www.officehelp.in/index/index.php
>
| |
| Graham R Seach 2005-08-24, 11:25 am |
| Lisheen,
If you're using Access user/group-level security, you can use the
NewPassword method to change an existing user's password. All you need then
is a table which contains a list of users, and the time since they last
changed their passwords. Check this table for the current user every time
the database starts up, and if it's time for them to change their password,
bring up your custom form and use NewPassword to change the password.
DbEngine(0).Users("Fred").NewPassword strOldPassword, strNewPassword
Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------
"Lisheen" <Lisheen.1u9ruh@NoSpamPleaze.com> wrote in message
news:Lisheen.1u9ruh@NoSpamPleaze.com...
>
> I was wondering if someone could tell me if it is possible to set MS
> Access to prompt or force a user to change his password every 90 days.
> I dont think it is possible using MS Access security but would it be
> possible if I set up my own security.
>
> I had thought of doing this by using a form into which a user enters
> his password which is then compared to the users password held in a
> table if they match the switchboard form is opened, this works but I
> still need to find a way of forcing the user to change his password
> every 90 days.
>
> If there is a way of doing this using MS Security I will gladly use
> this instead.
>
> Your help is appreciated.
>
> Rgds
>
> Nora.
>
>
> --
> Lisheen
> ------------------------------------------------------------------------
> Lisheen's Profile: http://www.officehelp.in/member.php?userid=510
> View this thread: http://www.officehelp.in/showthread.php?t=751489
> Visit - http://www.officehelp.in |
> http://www.officehelp.in/archive/index.php |
> http://www.officehelp.in/index/index.php
>
| |
|
|
|
|
|
|
|