User Login Timeout

[benchpolo]

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]

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