Ideas for multi user environment

[Guest]

I have practiced on a copied database how to set up user security. Basically
I am going to split the db but my question lies with either using a
switchboard or hiding the db.

There will be 3 users that can have access to all the reports however none
of the queries or tables.

All other users I want only to be able to view certain reports only...not
all reports and definatly not any of the tables or queries.

I know I can set the queries based on the reports I want them to run as RWOP.

I just want to find the simplest solution to this. Is it just easier to set
up a switchboard for those users with permissions to only certain reports.
And if so do you set that up to run by the login name.

Sorry if this is confusing.

 

[Joan Wild]

I would set up an unbound form as the switchboard i.e. don't bother with the
switchboard manager. You'll have more flexibility. For instance you can
hide/display various buttons depending on either the current user or on
whether they belong to a certain group. There is code in the security FAQ
you can use to determine if a user is in a certain group.
FAQ - http://support.microsoft.com/?id=207793

 

[Guest]

So should I still split the database?

I would set up an unbound form as the switchboard i.e. don't bother with the
switchboard manager. You'll have more flexibility. For instance you can
hide/display various buttons depending on either the current user or on
whether they belong to a certain group. There is code in the security FAQ
you can use to determine if a user is in a certain group.
FAQ - http://support.microsoft.com/?id=207793

 

[Joan Wild]

Always recommended. However, since it's secured, you shouldn't use the
splitter wizard as that will create an unsecured backend. Instead secure it
manually. See www.jmwild.com/SplitSecure.htm