User access - fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all. I have a question about how to setup some access rights to database
users. Here is the scenario: I have a form that uses a combo box with data
from a table. Also, many records in another table. My question is how do I
set some sort of a restriction, so that one user can see or access only
certain data from that combo box . Or maybe, depending on the logged in user,
that combo box field should update automaticaly with some info. How can I do
that? I know how to set rights to tables, reports, etc.. but not to fields...
:(

Thank you for your help.
 
Access does not give you field-level permissions.

One approach is to split off the sensitive fields into another table (joined
one-to-one), and set the permissions on that table.

If the data is not super-sensitive and you are mainly interested in
restricting the users' access through the interface, you can create your own
properties on the fields, and then design the interface to limit access
based on those properties. Details of this approach (and sample database) in
this article:
Field-level permissions
at:
http://allenbrowne.com/ser-55.html
 
Access does not give you field-level permissions.
Click to expand...

Actually it does, although it's a huge fiddle. The plan is to use RWOP
queries for all data access.

First remove all permissions for Users from the tables.

Logging in as an Admin, create selection queries like

SELECT ThisField, ThatField FROM Somewhere
WITH OWNERACCESS OPTION

and base all the forms, reports, listboxes etc on those queries. Allow
the Users permissions on the queries (read and write; not design), and
the Users will only have access to the particular fields.

Different user groups can have different sets of columns available via
their own queries.

You can use projection queries too (i.e. with WHERE clauses) to restrict
which rows the users can see too.

PS Yes, Allen, I know you knew that, but it seemed an appropriate place
to put it in the thread.. :-)

All the best


Tim F
 
Back
Top