Login ID Code for Access 2007 not working

[Mclaren]

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.

yes there are, i use two options depending upon the requirements of the person i am making thed DB for.

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.

[amangupts]

Thanks a lot for your reply. Can you help in building the query. As to what I need to write in the Query.

I believe this Part is already in the Code mentioned by me: 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

Please help me with the issue.

Thanks
Aman

[Mclaren]

I modified that code, will send what i got later on tonite. i am also busy reworking it so that the userrname box isn't a combo box.

why ?....well.....I don't want potential miscreants to have a head start in knowing a user name. I have also given my users an option to choose a "nick name" of their own as a login, so peter could use a nick like "Michelle". this limits miscreants from picking up that A: peter is a user, and B: trying out various words they think peter may use.

[amangupts]

Even "AWESOME" is a smaller word for the concept ur working on. Thanks a lot. It would be a wonderful value ADD to the security feature.

[Mclaren]

i just posted a 2010 db with a log in screen using text boxes in the "programming section" under "runtime error 2110", download it and check it out. i think it will run on 2007. (it does not have the count attepts feature though)

[amangupts]

Its not opening with 2007. Can you please check as to whether it can be converted to 2007.

[Mclaren]

Ok, give me a few days, i will organise it in 2007

[Mclaren]

Okay, i have a 2003 version which is pretty much working, you can open this in 2007:

This version uses text boxes for both user name and password, and stores the number of attempts tried for valid users. if the person trying to access the db uses any other name that is not stored, then the database doesn't store the attempts, but closes after 5 attempts (this value can be set in the properties table)

I may add to this example an option where if the user does not exist then the current user of the machine is stored and any attempt to try again from that particular machine will be prevented.

email me and i will send you a copy. its just over the upload size limit for this website.

[RuralGuy]

If you Compact and Repair and then ZIP the db, the size is 2MB's which should be enough I would think.

[Mclaren]

zipping....

[Mclaren]

zipped and uploaded.

I am sure this can be cleaned up a bit by the experts. but it works for me.