PDA

View Full Version : Password Change


skwilliams
12-27-2005, 03:59 PM
I have Active Server Pages which connect to an MS Access database. Within the DB is stored user information including usernames and password as the default password.

I'd like to create a page that asks them to change their password the first time logging in.

Any tips?

davidj
12-28-2005, 09:47 AM
in the table where you store uname and password add a field called timestamp

default this to null

then when your user first logs on do a check for null timestamp then redirect to the change password page

in the change password page within the update statement just add an extra field to update (timestamp)

You could really add any time as this is a marker but to do it properly you could use NOW()