paulmoscrop95
New member
- Local time
- Today, 09:34
- Joined
- Jul 9, 2011
- Messages
- 1
Hi,
I have a form within an Access 2003 database which allows the user to login. This works fine, I use a DLookup to verify the entered values match those in the tblUser entity.
What I want to do though is if the user enters there password wrong three times within the same session, there account is suspended. I have an attribute called AccountSuspended and one called IncorrectLogins. IncorrectLogins is a count of incorrect login attempts.
If a user enters their password wrong three times, I want the AccountSuspended attribute to be True. It is boolean data type. If the AccountSuspended is True, I want the Username and Password fields on the login form to be locked.
Also, I require when the form loads, a check to be carried out to find out what accounts are blocked.
Any help would be appreciated.
Paul.
I have a form within an Access 2003 database which allows the user to login. This works fine, I use a DLookup to verify the entered values match those in the tblUser entity.
What I want to do though is if the user enters there password wrong three times within the same session, there account is suspended. I have an attribute called AccountSuspended and one called IncorrectLogins. IncorrectLogins is a count of incorrect login attempts.
If a user enters their password wrong three times, I want the AccountSuspended attribute to be True. It is boolean data type. If the AccountSuspended is True, I want the Username and Password fields on the login form to be locked.
Also, I require when the form loads, a check to be carried out to find out what accounts are blocked.
Any help would be appreciated.
Paul.