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

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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.

Bikerman said:
Problem
In a multi-use database, how do I restrict a user from having access to
Click to expand...
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
Click to expand...
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
Click to expand...
while blocking access to those clients not assigned to him/her.
 
Back
Top