I would like to develop a password login form. I have a table setup with UserName, and Password. Everyone will have an initial password of "password". But the first time they log in to the database I want them to have to change their ready-made password. Then once they've established their new password it will be their password until they change it. So I also need a way for them to change their password.
One more thing... they should get three attempts to enter the correct password. If they don't enter their correct password after three attempts I want the database to close.
Has anyone done this before?