Is there an off-the-shelf MS Access product for med rec archive?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KonaKid1900 - 01 May 2005 06:30 GMT

Hi, we have several thousand old/inactive medical patients and we want to
scan their patient files into a database that we can use to keep these old
files off of our normal system. I am thinking of scanning the handwritten
records into PaperPort as pdf files but I am not sure if Paperport (and a
folder for each client) is the most effecient way to handle this). We could
be talking 30 or 40 thousand files over time. I am not even sure if I can
put the pdf files just directly into an Access database.

Thanks for any help or ideas.

Reply to this Message

Lynn Trapp - 02 May 2005 12:30 GMT

You might be able to store .pdf files in an Access database, but you don't
want to because it would cause your database to bloat pretty severly.
Instead, you should simply store the link to the appropriate file in either
a text field or a hyperlink field.

Signature

Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

> Hi, we have several thousand old/inactive medical patients and we want to
> scan their patient files into a database that we can use to keep these old
[quoted text clipped - 6 lines]
>
> Thanks for any help or ideas.

Reply to this Message