Switchboard to form security

[Guest]

I have searched the groups and Microsoft and can't seem to find my answer.
My database will be on the network shared with 5 different groups using
passwords. Each group is on the switchboard which when clicked on takes them
to the group's main menu form where they choose forms or reports from there.
Some of the forms and reports require input to run them. How do I give
access to the form for individual groups from the switchboard only without
getting the errors that you don't have permissions to tables, queries, etc.
since the main menu form contains table, queris and form which they are all
built from. I don't want users to be able to get in to another group's main
menu.

 

[Rick B]

Personally, I would create five separate switchboard forms and secure each
one so that only the appropriate group could open it. Then, Id create an
autoexec macro that would open the appropriate form based on who signed in.

If you search, there is a function out there that lets you basically say...

If IsInGroup(Manager) then...

You'd have to build that function into your database and use it in your
macro's criteria.

Hope that helps,

Rick B