Create Security through log in

[Francesca]

Hello,

I would like to set up some security because I will have 4
different groups accessing my database. I heard that
access has the ability to recognize certain users through
there network login Id and then whatever group they are
part of assign them to that view. These are the 4
different views/groups I would like:

(1)The Admin - which would be myself so I would have
access to everything.
(2)Users who would only be able to read the data to run
queries and have access to a couple reports.
(3)A User that would only have access to one table & form
and be allowed to add, update and delete records. And have
access to reports.
(4)Another User that would have access to a couple of
tables & forms being allowed to add, update and delete
records as well as access to some reports..

Would any one know how to go about doing this?

 

[TC]

You can do all of that using Access "user level security". The techniques
are fairly straightforward, once you understand them. Unfortunately,
understanding them to begin with is a significant undertaking! Plan on
spending >at least a few weeks< learning how to use these technmiques,
before yo even >think< about using them on your "real" database.

Read the response that I just gave to the post: "?Second post - customizing
security?" from Tammy. I gave her some suggestions on how to learn more
about Access security. The same suggestions ould work fine for you, as well.

HTH,
TC

 

[Jack MacDonald]

As TC said, Access' user-level security will do what you want.
However, this will be in addition to the network login -- they are two
different animals.
See the website in my signature for additional information that you
may find helpful.

Hello,

I would like to set up some security because I will have 4
different groups accessing my database. I heard that
access has the ability to recognize certain users through
there network login Id and then whatever group they are
part of assign them to that view. These are the 4
different views/groups I would like:

(1)The Admin - which would be myself so I would have
access to everything.
(2)Users who would only be able to read the data to run
queries and have access to a couple reports.
(3)A User that would only have access to one table & form
and be allowed to add, update and delete records. And have
access to reports.
(4)Another User that would have access to a couple of
tables & forms being allowed to add, update and delete
records as well as access to some reports..

Would any one know how to go about doing this?

=======================================================
Jack MacDonald
remove UPPERCASE LETTERS from email address
Vancouver, B.C. Canada
Info about MSAccess user-level security
www.geocities.com/jacksonmacd