I have a database that I have created for some staff. Some of the staff need
only to see a few items on the switchboard while others need to see all of
it. How can I limit access to certain switchboard items. Can I also create
users and passwords to the database?
--
Kathy

Kathy,
If you implement User Level Security, you can limit access to every object
in your database. The instructions for implementing User Level Security are
in the Security FAQ. There is a link to that document on the Security page
of my website. If you choose to do this you will need to read that document
several times and follow it to the letter. If you miss a step you might
either leave your database less secure than you think it is or, else, lock
yourself out of the database. Be sure to make a "practice" copy of the
database and try it out a few times before you begin on your actual
database. The Security FAQ is long and wordy. I have summarized the
information contained in it on this site:

http://www.ltcomputerdesigns.com/The10Steps.htm

I hope this helps.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conrad...essjunkie.html



"Kathy" <(E-Mail Removed)> wrote in message
news:528800BA-7AA3-4B1C-B649-(E-Mail Removed)...
>I have a database that I have created for some staff. Some of the staff
>need
> only to see a few items on the switchboard while others need to see all of
> it. How can I limit access to certain switchboard items. Can I also
> create
> users and passwords to the database?
> --
> Kathy

Thank you very much. I'll give it a try.
--
Kathy


"Lynn Trapp" wrote:

> Kathy,
> If you implement User Level Security, you can limit access to every object
> in your database. The instructions for implementing User Level Security are
> in the Security FAQ. There is a link to that document on the Security page
> of my website. If you choose to do this you will need to read that document
> several times and follow it to the letter. If you miss a step you might
> either leave your database less secure than you think it is or, else, lock
> yourself out of the database. Be sure to make a "practice" copy of the
> database and try it out a few times before you begin on your actual
> database. The Security FAQ is long and wordy. I have summarized the
> information contained in it on this site:
>
> http://www.ltcomputerdesigns.com/The10Steps.htm
>
> I hope this helps.
>
> --
> Lynn Trapp
> MS Access MVP
> www.ltcomputerdesigns.com
> Access Security: www.ltcomputerdesigns.com/Security.htm
> Jeff Conrad's Access Junkie List:
> http://home.bendbroadband.com/conrad...essjunkie.html
>
>
>
> "Kathy" <(E-Mail Removed)> wrote in message
> news:528800BA-7AA3-4B1C-B649-(E-Mail Removed)...
> >I have a database that I have created for some staff. Some of the staff
> >need
> > only to see a few items on the switchboard while others need to see all of
> > it. How can I limit access to certain switchboard items. Can I also
> > create
> > users and passwords to the database?
> > --
> > Kathy
>
>
>