setup

  • Thread starter Thread starter dmatmarc
  • Start date Start date
D

dmatmarc

I am trying to set up a database for a volunteer
organization and they want their members to updates their
own information but not have access to other member's
data. They also want to have certain people who can
access all the data in the database and certain officers
limited to certain database fields. My question is can
this be done in access and if so how?
Thank you all in advance
Please send answers to me at (e-mail address removed)
Marc
 
they want their members to updates their
own information but not have access to other member's
data.
Click to expand...

Hard way: use Access security to remove all users permissions from the
back-end tables completely, and use RWOP (Run With Owner's Permissions)
queries to get the data, with a WHERE clause that limits the data the users
can see.

Easier way: just use an appropriate query for the forms that limits what
the users can see. Not hard to subvert if they know their way round Access,
although you can make it inconvenient by hiding the database window, table
objects and so on.
They also want to have certain people who can
access all the data in the database and certain officers
limited to certain database fields.
Click to expand...

Provide another front end for management support with lots of queries, and
all the forms have Allow Editing switched off.

Use an Excel workbook or two to analyse the data directly for specific
analyses. Etc.

Hope that helps



Tim F
 
Back
Top