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

[KonaKid1900]

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.

 

[Lynn Trapp]

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.

--
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