Connecting Tech Pros Worldwide Forums | Help | Site Map

User Login Timeout

benchpolo's Avatar
Member
 
Join Date: Sep 2007
Location: Nevada
Posts: 92
#1: Mar 14 '08
I have an access database that has a user login (userid, password) information, but i need to know if there's a source code that I can utilize to lock the access database or close the access database after three attempts of entering incorrect passwords.

The warning message "The next incorrect password will lock you out of the system" should appear after the 2nd incorrect password attempt.

Please advise. Thanks in advance.

MindBender77's Avatar
Familiar Sight
 
Join Date: Jul 2007
Location: Pittsburgh,Pa USA
Posts: 232
#2: Mar 14 '08

re: User Login Timeout


I've done something similar in the past. I'm assuming you have a table which hold user names and passwords? You might have to add a "Yes, No" column call Locked. As for 3 attempts, you could run append queries to at temp table.

where txt_password <> table.Password

Then if the count of invalid login is greater than x then run update query to change Locked column of user to Yes.

Hope this helps,
Bender
Reply