Switchboard Passwords

[Guest]

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?

 

[Guest]

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.

 

[Guest]

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!

 

[Joseph Meehan]

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?

You may want to take a look at the user level security that Access has.

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can lock
everyone including God out.

Practice on some copies to make sure you know what you are doing.

 

[Guest]

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.