Switchboard Password

[Tom]

Is there a way to single out one
switchboard item for password
protection, and how do I do that?
I'm running Access 2000.

Tom

 

[Rick B]

I doubt it. Switchboards don't really let you do too much with that.
Besides, the user could still open the item that the switchboard points to.

If you want to prevent a user from accessing a form, query, report, etc,
then you need to implement user-level security and define the various access
to your objects.

 

[JNariss]

Tom,

Check out this link:

http://www.fontstuff.com/access/acctut08.htm

it gave me the ability to password protect certain forms on my
switchboard.

-Justine

 

[JNariss]

Then go to this link:

http://groups.google.com/group/micr...rotecting+Forms&rnum=1&hl=en#46088f9b5e69ce6d

Both these links helped me to create password protected forms. I copied
the code that Jeff Conrad provided and changed the quotation passwords
to the passwords that I wanted and everything worked fine.

 

[Jeff Conrad]

See this page on my site for any and all Switchboard Manager questions:

http://home.bendbroadband.com/conradsystems/accessjunkie/switchboardfaq.html

In your particular case, this specific area:

http://home.bendbroadband.com/conradsystems/accessjunkie/switchboardfaq.html#security

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

in message: