By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,336 Members | 2,315 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,336 IT Pros & Developers. It's quick & easy.

privileges and tables for different types of users

P: n/a

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?

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.