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

acccess rights

rcollins
100+
P: 234
I am in process of changing around my database frontends. I am curious if there is a way to make items not visible to users if they dont have rights. For example, if I was to have a switchboard for the main menu with items like accounting, behavior, nursing, etc, can I make it to where the accounting people only see the accounting info, but at the same time, someone in behavior may have access to nursing, but not need to see accounting. Is this possible?
Mar 19 '08 #1
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 374
Very much so. You have to use a well documented feature in MS Access that is called User Groups.

What you have to do is to create users into groups. Then once that has been created, you use the CurrentUser() function to see who is currently logged In and then you have a table maybe called UserConfig that will has sets of permissions for example:

Table Schema would be like:
Expand|Select|Wrap|Line Numbers
  1. ID     UserName     FirstName  LastName     DeptCode
  2. 1      UserID1      Fred       Flinstone    Accounting
  3. 2      UserID2      Wilma      Flinstone    Nursing
  4. 3      UserID3      Barney     Rubble       Behavior
  5.  
You would simply pull the value from the table that would see what department they're in and display information accordingly.

If you would like more detail and code examples, let me know and I can provide you with some.

Hope that helps,

Joe P.
Mar 20 '08 #2

rcollins
100+
P: 234
This sounds like I have to set up all of the users in the access database? I was hoping that I could use authenticationfrom active directory, we have a bit of turnover here and I would have to change a list like this often, when it is already updated in AD. Is this possible?
May 13 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.