Password protecting switchboard or sub-switchboards

[RickMorrison]

I am building a multi-leveled swithboard for one of my
applications in Access 2000, running on the companies NT
platform.

I am looking for a way to password protect sub-menus on
the switchboard.

Any help would be greatly appreciated.

Thanks,

Rick Morrison

 

[Stan Miezeiwski]

There are a couple of ways to solve the problem.

1. You can design forms for the sub menu choices and
password protect them. This is probably the easiest way.
2. If you are familiar with VB you can trap the error code
that occurs when you don't have permission for an item
called by the menu and pop up your own security message.
The sub menus will be visible but not accessible.

Hope this helps.