I want to create a login system within Access for a helpdesk program I am creating but I need it to be able to:
1)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)
2)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).
Someone has suggested that by using workgroups and user level security I can check the currentuser() and open an appropriate form by placing code on the form that is loaded (could be a menu or splash screen) after the username and password is entered. i.e. user enters username/password, use code to look at currentuser(), load appropriate form. The trouble is that I do not know how I could code this so that a form would open dependent upon whether they are an "administrator" with administrator level access or just a "user" had logged in and also so that the form could show the name of the person logged in (there would be nowhere in the workgroup file that would specify a relationship between the user id of the person logging in and their name, is it possible then?) Could anybody help!?
Thanks
1)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)
2)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).
Someone has suggested that by using workgroups and user level security I can check the currentuser() and open an appropriate form by placing code on the form that is loaded (could be a menu or splash screen) after the username and password is entered. i.e. user enters username/password, use code to look at currentuser(), load appropriate form. The trouble is that I do not know how I could code this so that a form would open dependent upon whether they are an "administrator" with administrator level access or just a "user" had logged in and also so that the form could show the name of the person logged in (there would be nowhere in the workgroup file that would specify a relationship between the user id of the person logging in and their name, is it possible then?) Could anybody help!?
Thanks