In a multi-user database, how to restrict access to certain record

[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.

 

[Allen Browne]

When the user opens the database, you must have some way of identifying
which user so you know the appropriate records. You then need a field in
your table that ties the record to a user.

In the Open event of the form, set its RecordSource property so only the
appropriate records are loaded. This example assumes that you have a
text-based StaffID field:

Private Sub Form_Open(Cancel As Integer)
Dim strSql As String
strSQL = "SELECT * FROM MyTable WHERE StaffID = 'xxxx';"
Me.RecordSource = strSQL
End Sub

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

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.