Field level security solution

[Guest]

Access does not support field level security as part of its security
mechanism. So, it seems we need to use a combination of form allow(addtions,
edits, deletions) and field enable/lock to implement security.

My application is rather complex security wise. Different fields are
updateable by different groups. It is goes so far that some fields are only
updated if the are responsible for a project (which requires VBA code in the
form current event).

The VBA is getting large in comparision with the rest of the apllcatiion. I
was wondering if anyone was aware of a commerical or perhaps freeware
solution to field level security. What I thinking what would do the trick is
some coding that checked Access group security against a table with form &
field names and access rights (may/may not add, update, delete at the form
and field levels).

Thanks,
Leif

 

[TC]

Access /does/ support field level security, by means of Run With Owner
Permission (RWOP) queries.

HTH,
TC

 

[Guest]

I think your confusing user level security with field level security, two
very different things.

 

[TC]

Well, you think wrong!

RWOP queries easily support field level security. You need to do some
more research.

HTH,
TC

 

[Guest]

I think right, your wrong in thinking Access supports field level security.

I've done programming in Oracle, now they have real field level security.

Execute permissions by owner has nothing to do with field security. You
might be able to use it, along with mutliple queries and VBA to set up some
kind of fake field level security. You can also use forms with lock and
enable properties. However, that is not field level security.

RWOP has nothing to do with fields. Its only execute permissions for
queries. Check Oracle for the real thing.

 

[TC]

I'm not going to argue with you.

TC