Logons?

[mariaw]

Hi

I am developing a system where I need to give people a logon username and password, so they can only access certain areas of the database.

For instance, if there name is John Smith and they work for the engineering department, they can only use the engineering form.

Any ideas?

Thanks!

Maria

 

[KeithG]

You can use Access security to assign work groups and permissions.

 

[The_Doc_Man]

I strongly advise you search this forum for articles on Workgroup Security as a way to control who can see what, but there are other pitfalls ahead.

You CAN use multiple forms for different groups but the fewer forms you have, the better off you are. On the other hand, the first time you have to share one form among many groups and just limit the records visible through that form, you are into another dimension.

You will probably have to learn some VBA (if you don't already know it) in order to be selective at the record level, because you will probably need to write some event code for the Form_Open event in order to establish the visibility of whatever a person is going to see.

 

[mariaw]

Thanks perhaps I should ask someone in IT if they now how to do it!!

 

[GaryPanic]

check in the samples prently of logins samples their
if an enginer have a main screen with options
engineer
brain surgeon
Fisherman
teacher
whatever
and on clicking of this button have the login form appear then limit the tables to the form behind this button

rather than doing this in VB - just tweak whats already out their

this would mean login tables per division ie if jon S is not in that table then his name will not appear on the drop down box and cannot login in

if you lok at the sample it will make sense

 

[Ecron]

in a networked environment.

i have tblUsers which has Username, Pwd, Access (privelages).

example: sbertram, bert, Basic

then, on my login form i use an overloaded Environ("UserName")(because of sandbox mode) in a locked text box that will give me "sbertram" when i'm logged onto my username(on the network). also in the login form is a password text box, and upon entering the password, using DLookup, the password is then verified. If successful the user is then steered off to where you want them to go.