I am new to Access database development. In my database I want to have a login system. The login system must validate the users and their passwords. If the username and password are valid, the user is logged in and uses certain parts of my database based on his/her user group and assigned access rights/accesslevel. This means the username must be
passed between forms in order to restrict certain controls on each form based on the users' access level. The switchboard must also display the name of the user currently logged in. The system must also restrict the number of failed logon attempts. This means if the user provide wrong password three times, his/her username/account must be locked and the system exits automatically. His/her account will then be re-enabled by the administrator before a next successful login. Finally, there must be a way to track the activities of every logged in user at any time. That table must be available only to the user(s) with administrative access rights.
Note: I want the usernames and passwords to reside in a table in the database. I don't want to use Windows or network logon information.