Login form which validates against a table

[Ro]

I need to set up a form with the username and login entry fields and two buttons login and cancel. Once the login button is pressed the info needs to be validated against a table of usernames and passwords within the database. Also if possible i would like to only permit 3 tries to login. After 3 failed logins have the application close. I would appreciat any help you could give me. I need this by tomorrow.

 

[TGHockett]

RO --

Since I have had problems with the security setup for Acc2k (mostly due to lack of tech detail knowledge on my part), I created a workaround situation as follows... its very clumsy but it works:

1: Created a table with username/department/userlevel. Userlevel alternative values were something like Admin/User/Mgmt.

2: Created a popup form based on the utility table with the three key fields and other relevent data you optionally desire, if any.

3: On the logon popup form, I placed a command button "proceed with logon" which I attached an on click macro that opened the main menu with conditions set something like:

-- IIf userlevel and/or username = Null
(msgbox-- no such username/userlevel is approved - etc) -- returns the user to the logon popup)
-- IIf userlevel = admin -- open frmAdminmenu
-- IIf userlevel = user -- open frmUserMenu
-- IIf userlevel = mgmt -- goes to frmMgmtstatus reports

Thats the main outline how I got this to work as clunky as it may be .... I would have let one of the ACC pros respond if you hadn't said you needed a solution by tomorrow ...been there/done that

Good luck ....

TGH

 

[tinaj]

TGHockett:

Is there any way you could send me an example of how you made this work?

Many Thanks,

Tina