any help?

[11am]

im hoping that some could help me with this problem i have. i have a database in access (xp) and i am using switchboards i have a main swtich board leading to other switch boards. what i would like is to set a password for each option on the main switch board but i have no idea how to.

 

[Pauldohert]

I don't know what you are trying to acheive exactly - but multiple passwords could get tricky, could you make each user log on with a password and assign them differant permissions to access the switchboards?

 

[dopedealer]

Theres no need for mutiple user logins, just create a text box on the main switchboard, set its input mask to PASSWORD and on the Current/Open event of the main switchboard code accordingly ...so for example:
If Text0.value = "123Pass" then
option1.enabled = true
ElseIf Text0.value = "345Pass" then
option2.enabled = True
Else
Option1.enabled = false
Option2.enabled = false
End if

And on the Load event of the Main Switchboard:
Option1.enabled = false
Option2.enabled = false
etc etc...

Chris

 

[Pauldohert]

Lots of users, lots of passwords, changing of the passwords etc etc, I still think a password for a user and giving a user permissions would be easier in the long run.

Paul

 

[dopedealer]

Well,
I use automatic logging in for my databases, the user id is detected, matched and the permissions are set accordingly, saves users the trouble of remembering yet another password.
Chris

 

[Pauldohert]

I was just suggesting permissions for users really, as opposed to separate passwords for each bit of functionality.

 

[dopedealer]

yeah i get what you mean, thats the right way to do it, and like i said i use that method but its all done through A.I. rather than the user having to log in, the users domain and user ids are picked up from the active directory servers and the stations they are on and then the ids are matched with a table and accordingly the user permissions are setup automatically for either Viewer/In Putter or Administrator.
chris