In a multi-user database, how to restrict access to records

G

Guest

Problem
In a multi-use database, how do I restrict a user from having access to certain records and allow it for others.
The scenario is as follows:
The database handles records for a mental health organization.
According to HIPPA regulations (new law passed about security of medical records), a clinician should only have access to those clients assigned to him/her.
How do I allow this clinician to have access to his/her clients records while blocking access to those clients not assigned to him/her.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

In a multi-user database, how to restrict access to records 5
In a multi-user database, how to restrict access to certain record 1
multiple users' simultaneous access to a MS Access database 4
multiple users' simultaneous access to a MS Access database 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
querie - restrict reslts to records which match value in a form fi 1
Matching records table in a multi-user environment 2
Access MS Access - Multi User Lock Issue 0

Top