>How do save access right for your different screens and functionnalities (in the vb code or in a db)? How do you define your profile and how do say that a profile have one or more specific access right. How do you associate user to profile?
>
>With your way, if you want to give access to a specific user to a specific function, do you need to make change in your vb program and recompile it? The way I am doing it right now I would need to make change and recompile.
>
>I know it is a lot of question, but thanks for answering.
>
>Thanks.
Everything is in a database.
I have one table for all the access rights on my functionnality.
I have one table that defines profiles.
I have one table that defines users (which include a field telling the user'S profile).
I have one table that contains access rights specific to the user. If the user only have those defined by the profile, this table is empty for this user.
So, recompiling is not necessary when you need to change access rights for one user.
Come back if you need more details.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com