Prompt to change password in Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lisheen - 24 Aug 2005 14:00 GMT

I was wondering if someone could tell me if it is possible to set M
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 b
possible if I set up my own security.

I had thought of doing this by using a form into which a user enter
his password which is then compared to the users password held in
table if they match the switchboard form is opened, this works but
still need to find a way of forcing the user to change his passwor
every 90 days.

If there is a way of doing this using MS Security I will gladly us
this instead.

Your help is appreciated.

Rgds

Nora

--
Lishee
Visit - http://www.officehelp.in | http://www.officehelp.in/archive/index.php | http://www.officehelp.in/index/index.ph

Reply to this Message

Rick B - 24 Aug 2005 14:19 GMT

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.

Signature

Rick B

> 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.
[quoted text clipped - 15 lines]
>
> Nora.

http://www.officehelp.in/index/index.php

Reply to this Message

Graham R Seach - 24 Aug 2005 15:48 GMT

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

> 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.
[quoted text clipped - 15 lines]
>
> Nora.

Reply to this Message

Lisheen - 24 Aug 2005 18:09 GMT

Thanks very much for your help, sadly I have hit a slight snag. I se
up MS user / group level security on my database which seemed to g
fine. But now when I open any MS Access database even ones which neve
had a password they are all now looking for a user name and password.
How can I undo this. As always your help is very much appreciated

--
Lishee
Visit - http://www.officehelp.in | http://www.officehelp.in/archive/index.php | http://www.officehelp.in/index/index.ph

Reply to this Message

Joan Wild - 24 Aug 2005 20:58 GMT

Answered in the security newsgroup.

Signature

Joan Wild
Microsoft Access MVP

> Thanks very much for your help, sadly I have hit a slight snag. I set
> up MS user / group level security on my database which seemed to go
[quoted text clipped - 11 lines]
> http://www.officehelp.in/archive/index.php |
> http://www.officehelp.in/index/index.php

Reply to this Message