Ideas for multi user environment

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
So should I still split the database?

Joan Wild said:
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
Click to expand...
 
Back
Top