yes there are, i use two options depending upon the requirements of the person i am making thed DB for.
Is there any way to record the number of attempts made by any person in database by inserting a column in the main table or otherwise as well.
1: count the number o attempts with in the login screen, each failed attempt adds 1 to the running total : eg, define a value lets say : intLoginAttemptCount and then on each fail you will have intLoginAttemptCount = intLoginAttemptCount + 1
then if the max number is reached i.e.
if intLoginAttemptCount = 3 then
docmd.quit
end if
2: set up a column in your users table for the count. Use an update query(i think, or maybe an append qurery, can't remember right now) to change the value held in the tale for a given user for each attempt made. This way you can be sure that even if the user closes the database, the number of attempts is stored and further attempts to restart and try another 3 times will not be an issue.
the value can always be set to 0 once the user makes a valid attempt.