By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,640 Members | 2,167 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,640 IT Pros & Developers. It's quick & easy.

User Login Timeout

P: 142
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.
Mar 14 '08 #1
Share this Question
Share on Google+
1 Reply

P: 234
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,
Mar 14 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.