Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / September 2005

Tip: Looking for answers? Try searching our database.

User access - fields

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Alex - 23 Sep 2005 18:29 GMT
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.
Allen Browne - 24 Sep 2005 10:49 GMT
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

Signature

Allen Browne - Microsoft MVP.  Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Hi all. I have a question about how to setup some access rights to
> database
[quoted text clipped - 10 lines]
>
> Thank you for your help.
Tim Ferguson - 24 Sep 2005 19:42 GMT
> Access does not give you field-level permissions.

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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.