Switchboard Passwords

S

sduffield2

I'd like to create a switchboard to limit access to parts of my database.

The records in my database have two "owners". I've got my initial
switchboard to go to queries with one, the other or both owners' records.
What I'd like to do is have it request a password that is dependant upon
which querie I go to. That way I can let the specific record owner take a
bit more ownership of their records without giving them access to other
records. Also, in time, it'll make it possible for the owners to provide
guest access to other queries within their own records that limit the
information available.

All I've found is information on setting a single password for the entire
database. Has anyone else tried to do this?
 
S

schasteen

I have had some success with creating a table where I store usernames,
passwords, and permission values. I then have the database start up with a
login screen that confirms the user and password, queries the permission
values and pass them to the switchboard in hidden text or check boxes.
Depending on the sophistication of the users, you may have to set
administrative permissions so the users cannot view or modify this table.
This is not air tight, but it provides enough security and has worked well
for me.
 
S

sduffield2

That's a clear solution to my question. Could you tell me more about how you
use hidden text or check boxes? I'm not sure how they would help me in
creating an obstacle for those who want access to the main switchboard.

Thank you!
 
S

schasteen

You basically add an If checkbox = -1 then open query, form or any other
operation else mgbox("you do not have the proper permission") (I know this
not very clean, but just giving a general example). Just name you checkboxes
and or textboxes well so you can easily debug and remeber.
 
Top