Youssef
I use a user table with a field for permissions. That same field is a foreign key to a UserGroup table. When a user opens the database, I get his network name using Environ("USER"). From that, I can check which group he is in and set a global variable. My main menu startup form is then coded to show or hide buttons based on that variable. Subsequent forms's properties are also set.
If you Google "ms access security 2010" you will find several articles on how developers set up security in Access.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com
--- In MS_Access_Professionals@yahoogroups.com, "Youssef" <youssef2309@...> wrote:
>
> I have a Access 2007 database and it containes around 200 form & report and around 15 users use this database
>
> my solution to control the users which to open (for read or edit) and which to not open is to create a code and copy this code inside each form and report which means i copy this code around 200 time
> this is not logical
>
> so, what is the best way to make a user-level security in Access 2007
>
> thanks in advance
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar