Groups, Users and rights (on functions and forms)

Hi,

I need to create a database to manage the users and user's right that belong to groups. Each user in each group have difference rights on the menu (visible or disible) and on the forms (user can Add, edit or not). How to do this? are there anyone have experiences on this? What technique should I use to the rights of user when they login to the system?

Thanks in advance,

Trung Luu

As I know exist there some VB-Code that handles this problem.

The Standard-System is this:

You have Groups for any kind of forms to Access, AddNew, Edit, Delete, Find in this form.

You have groups they include other groups. That means that you have an tree.

Then you have individual user rights.
The individual user rights overhtrow the group rights.

If you want to make it automaticly, you should detect every form and every control on the form. Then just create a form where you can click on Allowed or not allowed for each control.


Franky

Hi Franky,

Thank you for you reply.

Could you please tell me where I can get the VB-code for this?

Regards,

Trung Luu