privileges and tables for different types of users

[Smriti Dev]

Hi There,

I am designing a database and want to give privileges to a type of user so
they only view some fields of a table when they are a certain type in a
database. They should be able to modify the data. My question is if this is
possible and if so, how can I do it? Does any one have any good suggestions
on what I can read to do this?

[Jack MacDonald]

The basic tool you use is User Level Security. Once that is
implemented, you can begin to use the CurrentUser() function as a
criteria in queries to limit the records the a user can interact with.
You can also implement Read With Owners Permission queries to limit
the fields that are visible, and you can use CurrentUser() to control
the logic flow of your forms.

You can also find VBA code to deternime whether a user is a member of
a particular group, and take appropriate action.

Start with implementing User Level Security. Links to several
documents on the website in my signature.
On Mon, 27 Jun 2005 21:11:31 GMT, "Smriti Dev"
<sm********@utoronto.ca> wrote:

Hi There,

I am designing a database and want to give privileges to a type of user so
they only view some fields of a table when they are a certain type in a
database. They should be able to modify the data. My question is if this is
possible and if so, how can I do it? Does any one have any good suggestions
on what I can read to do this?

**********************
ja**************@telusTELUS.net
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security