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

Form Privileges and Logging

P: 1
Hello all,

I started making this access database for our company, but there are some forms I really need help with to complete the application.
First of all, I'd like to know if there is a way to make access levels for each user who enters. I made a table with user names and passwords including a numeric field called "level" for example 1 stands for admin, 2 stands for user with edit/add privileges and so what kind of VBA code I need? sample databases are much appreciated. Now if I have that up and working correctly I would like to know if it is possible to log every user's entry to the database like some kind of "Activity Log".
thats about it,

Best Regards,
Nov 17 '08 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,487
First of all you need to start from a slightly different perspective with the questions. It works better if each thread is started with a single question. Nothing too open-ended.

I will deal here with the concept of coding user levels into your forms.

You should consider having tables for the forms (objects really - reports would be covered in a very similar way), as well as the table you already have for the users. All forms (objects) should then be opened using a single procedure (like the switchboard that's created by the wizard). In this procedure the code would handle comparing the user's level against the level assigned to the object.

From there it should be reasonably straightforward. Welcome to Bytes!
Nov 17 '08 #2

Post your reply

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