User access setup

[Lynn73]

Hi
I am trying to set up access for multiple users, whereby they will open the database to see a switchboard with a list of all the reports they can run/view. I am a bit flummoxed by all the various security books I have read, is it possible to set this up without losing my own access into the tables and queries, so that when I open up the database I dont have to go via the switchboard.
Thanks

 

[Guus2005]

You can create a switchboard for each group showing what they are authorised to do.
You can set the startup form or function to be executes. Choose a function let say: StartUpMain(). In this function you can check the users permission and according to that permission startup a different form.

HTH