Form Privileges and Logging

[Koulde van Louard]

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 on...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,

[NeoPa]

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!