limiting the number of login attempts

[John]

The current app is using a MDW file. The users need to sign in before
being able to use the app. There is a user table with the id and
password for each user. It is now being requested that the user is
locked out after 5 signin attempts that fail (consecutive attempts).
This would then set a flag in the user table in the field
'LockedOut". Is this possible to do? If so how so? I have never had
to limit the number of logons before? Any example(s) to review?
Thanks.... John

 

[Douglas J. Steele]

As far as I'm aware, it's not possible. That's because none of your code
will run until the user logs into the database, therefore you can't do
anything to stop them.

 

[John]

As far as I'm aware, it's not possible. That's because none of your code
will run until the user logs into the database, therefore you can't do
anything to stop them.

--
Doug Steele, Microsoft Access MVPhttp://www.AccessMVP.com/djsteele
Co-author: "Access 2010 Solutions", published by Wiley
(no e-mails, please!)






- Show quoted text -

Thanks. I questioned if it was possible with the mdw...John

 

[Douglas J. Steele]

No. Code doesn't exist in MDW files.

 

[John]

No. Code doesn't exist in MDW files.

--
Doug Steele, Microsoft Access MVPhttp://www.AccessMVP.com/djsteele
Co-author: "Access 2010 Solutions", published by Wiley
(no e-mails, please!)








- Show quoted text -

What I was getting at was that the mdw does its password request
before any code runs. Which is why I questioned if the limiting of
signins was possible.
.... John

 

[Douglas J. Steele]

At the risk of sounding like a broken record, it isn't possible. Live with
it!

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/djsteele
Co-author: "Access 2010 Solutions", published by Wiley
(no e-mails, please!)

No. Code doesn't exist in MDW files.








- Show quoted text -

What I was getting at was that the mdw does its password request
before any code runs. Which is why I questioned if the limiting of
signins was possible.
.... John