Unanswered: Creating a Login Form for MS Access 2002
I am currently working on a "Help Desk Database project for TAFE". And one of the things I would like to know how to do is create a logon screen where the help desk operator enters there username and password and them accepts them, and allows them to move on. To enter calls etc.........
It needs to be able to reject the person giving them an error about either there password or username is not correct and then the abiltity for them to type it back in again.
There will be other people using this database like a Tech and a Manager so there will need to be some sort of drop down box allowing them to select there area of work..
An example would be username help1 and pass: helppass
username tech1 pass: techpass
Any help would be greatly appreciated!!!
Another little trick I use, to prevent certain types of people from breaching security, is put the Quit command in the OnClose procedure on your login form. That way, when trying to bypass the password by going into design mode, it's bye bye!