Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Jan 2001
    Location
    FL
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    HIPPA Compliant Table (2000)

    I have a tbl with 300,000 records. One of the text fields is an address. For example: 1234 Main St. or 123 1st Ave or I-75 & SR 50 and others. I need to provide this table to prospective bidders. Federal laws prohibit me from providing the complete address. I will need to change the address to read: 123X Main St. and 12X 1st Ave. I-75 & SR 50 could remain unchanged. I've tried using Find & Replace and an update.qry to no avail. Can this be done in Access? Any thoughts are greatly appreciated!!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: HIPPA Compliant Table (2000)

    What is the exact rule? From your examples, I would guess "If the address starts with a number, change the last digit of that number to X." Is that correct, or are there exceptions, additional cases, etc.?

  3. #3
    New Lounger
    Join Date
    Jan 2001
    Location
    FL
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: HIPPA Compliant Table (2000)

    Correct. If the Address is a "normal address", change the last digit of the address number to an X. This makes it un-identifiable in terms of Federal Law. Sometimes there are numbers in the street name which should not be changed. If the Address is a cross street or intersection, then no change is necessary.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: HIPPA Compliant Table (2000)

    Start by making a backup copy of your database.
    Create a query based on your table. Add the Address field (or whatever

  5. #5
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: HIPPA Compliant Table (2000)

    Another approach might to use one of the following:

    1. Scramble, Ken Wilkinson, Different Bases For Different Places, http://www.DB4DP.com

    2. Data Scramble, Created by Roger Carlson, http://www.RogersAccessLibrary.com

    HTH

    John

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •