Login form and ID field in novell environment

[bseche]

( The reason I want it like that I want to stop people from using other user name to enter information, also be able to link their login info to the Main form).
I have a program that 2 types of people are going to use. The regular users and the admin users.
I’m not sure if I should Access 97 security features or create my own. I want the users to enter the program like usual. Once they click on the Main form( maybe a Login form would come up first) In the Login form they would be ID field ( combo box) Full Name field ( linked with combo Box) and Password Field ( pre setup for them). ID Field and Full Name field would also exist in The Main Form.
I want an option for them to Enter their user ID or choose their Id from a combo box and once they select their id they would automatically enter their name in the Full Name field and then they must enter a Password. ( If any of the information is not valid it would let them know to notify administration) ex. User ID does not exist or wrong password.
Once all the information enters are valid the main form will open up and As soon as the form opens their ID and Full name should be there. ( only on current record and or New record). Should I make The ID and Full name field mandatory even though the login form would put it there after a successful login.

How should I get started. Thank you In advance

 

[Chris RR]

I have usually avoided the Access security and done my own. Quite often, in my security table for a system, I'll have a field called "security_level" or something like that, set to maybe "A" for admin users, "U" for update users, "R" for read-only types. All users log in exactly the same way. Then my code checks their access level, and directs things accordingly.

Why have them enter their names? Userid & password should be enough, and I would not make userid a combo box (you don't want to give the average hacker a head start).

You can always store the user's name in your security table, then put the name & ID in a global variable when you have a successful login. From there, it can be used on any form, or popped into a record.

P.S. Only admin users (or maybe "Super Admin User"--you?) should have rights to the security table.

 

[bseche]

The reason they need a user id and name and password is. that when they do login into access. They will be login in as their Initials ex. JD. Once they enter their initials there user name should show up in the "Full name" field. Then they would enter their password.
Can you send me a copy of your form it does not have to have records, because visual presentation is the only way i can understand what you suggested.