I am creating a Helpdesk system in Access and I would like to create a simple login system. I would have a login table with the Fields "USER ID", "PASSWORD", "ACCESS LEVEL" and "STAFF ID". When someone enters the database I would like a form to pop up which would request the user to enter their ID and password. What I need the login system to be able to do is:
1)Check that the user ID and password match from the login table
2)Direct the user to a form dependent upon their access level (there will be a form for helpdesk users and a unique one for the helpdesk manager ie. 2 acess levels)
3)Store the user ID the user logged in with in a temporary table (known as a control table in Delphi) whilst they are logged in such that for example an object on the form could display the logged in user's name (a staff ID in the login table allows a relationship between it and a STAFF table to be made).
I'm sure that this would require VBA programming of some sort but am a novice when it comes to VBA!
1)Check that the user ID and password match from the login table
2)Direct the user to a form dependent upon their access level (there will be a form for helpdesk users and a unique one for the helpdesk manager ie. 2 acess levels)
3)Store the user ID the user logged in with in a temporary table (known as a control table in Delphi) whilst they are logged in such that for example an object on the form could display the logged in user's name (a staff ID in the login table allows a relationship between it and a STAFF table to be made).
I'm sure that this would require VBA programming of some sort but am a novice when it comes to VBA!