Setting security access by field

  • Thread starter Thread starter Marco Castro
  • Start date Start date
M

Marco Castro

Right now we have a form that one person starts to work on then another
person finishes it off. Is it possible to setup the security so that the
second person can only edit a few certain fields on the form? I know that I
could probably just lock the fields that they are not allowed to enter using
VB but I was wondering if its possible to do this using the built in
security manager. Thanks.
 
You will need to use Read With Owners Permission (RWOP) queries. It
would be a bit complex, but you would need to make several queries
that could be used by different people. The editing form would
dynamically change its recordsource, depending on the value of
CurrentUser()

RWOP queries are explained in the Microsoft Security FAQ. See the
website in my signature for a link.

Right now we have a form that one person starts to work on then another
person finishes it off. Is it possible to setup the security so that the
second person can only edit a few certain fields on the form? I know that I
could probably just lock the fields that they are not allowed to enter using
VB but I was wondering if its possible to do this using the built in
security manager. Thanks.


=======================================================
Jack MacDonald
remove UPPERCASE LETTERS from email address
Vancouver, B.C. Canada
Info about MSAccess user-level security
www.geocities.com/jacksonmacd
 
Back
Top