Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CREATING A LOGIN SYSTEM FOR A HELPDESK PROGRAM

Status
Not open for further replies.

gyli84

MIS
Aug 6, 2001
67
GB
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!
 
Might be better to use VB. You can use VBA with excel or even create an Access database. WHat you should be asking is how many users will be accessing the database?
It seems from your subject that it is a helpdesk call log.
If you want to post your email address will send you part of a VB program which has what your after..
 
My E-mail address is garyli@weconnor.com, thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top