A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old July 7th, 2004, 07:38 AM
Bikerman
external usenet poster
 
Posts: n/a
Default In a multi-user database, how to restrict access to records

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.

--
The fun is not in the speed but the sudden stops!!!
  #2  
Old July 7th, 2004, 07:49 AM
Allen Browne
external usenet poster
 
Posts: n/a
Default In a multi-user database, how to restrict access to records

If you must post the question to more than one group, please post a single
message, with all the group names specified together. This way replies are
tracked across the groups.


  #3  
Old July 11th, 2004, 01:51 AM
Bikerman
external usenet poster
 
Posts: n/a
Default In a multi-user database, how to restrict access to records

N00b mistake!
Sorry!
--
The fun is not in the speed but the sudden stops!!!


"Allen Browne" wrote:

If you must post the question to more than one group, please post a single
message, with all the group names specified together. This way replies are
tracked across the groups.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Useless Access 2003 tired, angry, sucidial and bored General Discussion 10 July 21st, 2004 11:52 PM
Need help with Access decision aualias General Discussion 23 June 21st, 2004 02:04 AM
Access Database File Size Maybeso General Discussion 2 June 7th, 2004 03:16 AM
Please Help, The database is in an unexpected state; Microsoft Access can't open it. Gary A. Hollenbeck New Users 2 May 20th, 2004 05:42 PM
Can't add many database records per form template Ashley Dreier Setting up and Configuration 0 September 19th, 2003 06:01 PM


All times are GMT +1. The time now is 07:01 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.