UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Using Access As A Clinical Database    
 
   
lbster
post Aug 2 2018, 02:27 PM
Post#1



Posts: 19
Joined: 30-September 15



Hello All,

I was wondering your opinion if MS Access would be proficient enough to be used as a clinical database (patients, history, etc)? Let me be clear this is for an individual family practice, not some large corporation. They have maybe 5 employees and I'm not sure how many active patients (probably under 1000). I know there may be unknowns of what other things they may need it for, but in general, would it be good enough to be used as an interface and relational database in this scenario? Maybe I need to ask, what flags would tell me not to use Access?

Thanks for your time/thoughts,

Lance
Go to the top of the page
 
theDBguy
post Aug 2 2018, 02:34 PM
Post#2


Access Wiki and Forums Moderator
Posts: 72,963
Joined: 19-June 07
From: SunnySandyEggo


Hi Lance,

As far as using Access as a basis for a business database is not going to be the problem for a small- to medium-size business. However, in this particular scenario, I think you will find complying with the laws and regulations surrounding healthcare, such as HIPAA (for example), would be the most concern you'll have when deciding if Access would be suitable in your case. My first instinct would be a "no," but I am not fully versed with HIPAA requirements (for example).

Just my 2 cents...


This post has been edited by theDBguy: Aug 2 2018, 04:07 PM
Reason for edit: HIPAA is just used as an example

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
cheekybuddha
post Aug 2 2018, 02:35 PM
Post#3


UtterAccess VIP
Posts: 10,258
Joined: 6-December 03
From: Telegraph Hill


Yes and no!

Access certainly has the capability, if properly designed, to run such a database.

Your real issue will be security. Unfortunately, Access is not very secure (in its native form, at least). There are many things you can do to mitigate this, but nothing will be 100% foolproof.

A different backend such as SQLServer or MySQL (or others) is one way to mitigate such a risk.

However, to get a usable database, for your whole practice will be a pretty major undertaking.

The benefit will be that you can make it bespoke for your working practices.

hth,

d

--------------------


Regards,

David Marten
Go to the top of the page
 
GroverParkGeorge
post Aug 2 2018, 02:47 PM
Post#4


UA Admin
Posts: 33,260
Joined: 20-June 02
From: Newcastle, WA


An Access front end with a SQL Server back end would probably work best.


--------------------
Go to the top of the page
 
JonSmith
post Aug 2 2018, 03:57 PM
Post#5



Posts: 3,691
Joined: 19-October 10



QUOTE
I think you will find complying with the laws and regulations surrounding healthcare, such as HIPAA


Dont assume its the US dbguy. I used to get that alot and it got abit tired hearing about being told I won't be compliant with a rule that didn't apply to me. Fine to point it out but perhaps add the caveat of 'if you are in the US we have this rule'.
Go to the top of the page
 
theDBguy
post Aug 2 2018, 04:04 PM
Post#6


Access Wiki and Forums Moderator
Posts: 72,963
Joined: 19-June 07
From: SunnySandyEggo


Hi Jon,

Good point. Do you think there could be countries without healthcare regulations? The HIPAA part was just my attempt to give an example of a possible healthcare law. I guess I could have worded it better other than using "such as."

Thanks!

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
projecttoday
post Aug 2 2018, 05:49 PM
Post#7


UtterAccess VIP
Posts: 9,983
Joined: 10-February 04
From: South Charleston, WV


So you want to use Access for appointments, billing, storing basic patient info? What about as part of the treatment (storing charts, x-rays, etc.)? Have you looked at any commercially available software?

--------------------
Robert Crouser

My company's website
Go to the top of the page
 
zaxbat
post Aug 2 2018, 06:31 PM
Post#8



Posts: 1,181
Joined: 26-January 06
From: .....the wiregrass (either you know or you don't)


The commercially available software is insanely cost prohibitive (not to mention bulky, clunky, slow, and counter-intuitive)....pretty sure that is why the OP came here with their questions.
This post has been edited by zaxbat: Aug 2 2018, 06:37 PM

--------------------
Kindest regards, and Cheers!
ZAX

A picture is worth a thousand words and a zipped DB is worth a thousand pictures.
Oh, and....please don't disappear into the Twilight Zone.... Holler back with your results!
Go to the top of the page
 
JonSmith
post Aug 3 2018, 02:11 AM
Post#9



Posts: 3,691
Joined: 19-October 10



QUOTE
Good point. Do you think there could be countries without healthcare regulations? The HIPAA part was just my attempt to give an example of a possible healthcare law. I guess I could have worded it better other than using "such as."


Thanks DbGuy! Good edit smile.gif
Now thats a very broad question, a country without healtcare regulations, probably not, without data regulations, unlikely, without data regulations that specifically exclude Access as a database, thats certainly the case.
In the UK we could use it for storing clinical information but it had to be on our secure networks etc and protected by a password. There are often examples of as much clinical data being saved in an Excel file so I think the pragmatic approach they take is smart. Make sure your infrastructure is secure and that your staff are highly trained in information governance, then the less secure things like a spreadsheet or Access database are less of an issue. It also means you can start off some things small scale and upscale when appropriate rather than having to start in a SQL server.

I am certain there will be a ton of data leakage and not secure stuff in US hospitals, banning specific applications doesn't help, its a data protection culture and infrastructure you need to create.
For example, where I am now, they have none of it, passwords are shared, screens are left unlocked, all of that is waaaaay more of a risk than data in an Access database.

JS
Go to the top of the page
 
lbster
post Aug 3 2018, 04:57 PM
Post#10



Posts: 19
Joined: 30-September 15



Thank you guys for all the insight. Much appreciated! After talking to client yesterday, I found out that they use Praxis, so probably not rocking that boat to implement an Access DB even though they mentioned a lot of shortcomings with the software.

Thanks again,

Lance
Go to the top of the page
 
MadPiet
post Aug 3 2018, 07:25 PM
Post#11



Posts: 2,438
Joined: 27-February 09



I built clinical databases in Access a long time ago, so I know it's possible. Being that I'm in the US, the HIPPA stuff made me nervous - only because I didn't want to be responsible for confidential data (social security numbers etc) being so easy to steal. Can you use Access as a front end to your database and just create linked tables?
Go to the top of the page
 
Flint
post Aug 3 2018, 09:35 PM
Post#12



Posts: 30
Joined: 24-September 14



It is feasible and it is profitable.

I have written and supported several clinical applications that are in MS Access for the last 20 years. I have been inspected by the FDA (have 510K and certification) and have survived many HIPAA reviews by small to large institutions. Security is only as good as the organization's internal security policies and work practices.

The things I have written and passed security reviews and HIPAA:

Clinical Reporting System: Point of service with DICOM imaging, import of structured report files from ultrasound modalities for measurements, etc
HL7 Parser and Importer
HL7 Results Outbound Results
HL7 Billing interface (DFTs)

I have these applications in local onsite networks and in data centers running within VMware.

I have some sites that have hundreds of thousands of records.

Regards.

Go to the top of the page
 
theDBguy
post Aug 3 2018, 10:41 PM
Post#13


Access Wiki and Forums Moderator
Posts: 72,963
Joined: 19-June 07
From: SunnySandyEggo


Hi Flint,

Thank you for sharing your experience with us. This just goes to show Access can do almost anything. This is very encouraging to know.

Cheers!

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
JonSmith
post Aug 4 2018, 03:15 AM
Post#14



Posts: 3,691
Joined: 19-October 10



QUOTE
Security is only as good as the organization's internal security policies and work practices.


Precisely! I too have made clinical databases, I was in the UK at the time though so none of that HIPPA or FDA nonsense. Our hospitals are all just ran by the NHS (Which is much better than the private healthcare system tongue.gif) and it has regulatory bodies too but it concerns itself more with internal policies and practices rather than individual applications.
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    20th August 2018 - 12:10 AM