J
Joe Robeen
I have an Access 2003 database with form level security that works great. I
utilize the autoexec macro to run some code that grabs the users network ID
and stored it for the duration on that session. For each form that a user
tries to navigate to throughout the UI, I utilize a roles table that links
that users Network ID to their role within the application (simply either
"Edit" or "Read-Only"). Then depending on what role is returned I open the
desired form normal or read only, thus granting them appropriate form level
rights. The problem is of course that powers that be have declared they want
a few select people to be able to edit certain fields, but not all. For
instance, they want a clerical staffperson to be able to change a status
field and a date, but not any other information on the page. I can see
several ways to approach this but I was wondering what would be the most
practical approach?
A) Remove form level rights for these users and set enablement of each
control on those forms? (Lot of work seems like to me)
B) Create popup form with the editable forms for these users by which they
can edit those select field with form level rights in place?
C) Build more robust role management module? Aaah!
Help! Any ideas and insights would be greatly appreciated...this one has me
stumped.
utilize the autoexec macro to run some code that grabs the users network ID
and stored it for the duration on that session. For each form that a user
tries to navigate to throughout the UI, I utilize a roles table that links
that users Network ID to their role within the application (simply either
"Edit" or "Read-Only"). Then depending on what role is returned I open the
desired form normal or read only, thus granting them appropriate form level
rights. The problem is of course that powers that be have declared they want
a few select people to be able to edit certain fields, but not all. For
instance, they want a clerical staffperson to be able to change a status
field and a date, but not any other information on the page. I can see
several ways to approach this but I was wondering what would be the most
practical approach?
A) Remove form level rights for these users and set enablement of each
control on those forms? (Lot of work seems like to me)
B) Create popup form with the editable forms for these users by which they
can edit those select field with form level rights in place?
C) Build more robust role management module? Aaah!
Help! Any ideas and insights would be greatly appreciated...this one has me
stumped.