[AccessD] Case management and external files

Hi Jim,

I do this frequently.

I copy the files that a user has selected and move the copies to a specific
directory on the server where the db is stored.  I also make the copies
read-only so that when someone opens it (with a hyperlink path created at
run-time in code), they can't store changes over the stored copy.  I use
File Systems Object for this.

I guess an inbound fax would need to be scanned electronically to be stored
as a file.  Unless there is software that can be used to view a fax and save
it as a separate file without printing it out.

I have figured out how to pull emails from Outlook and save them as separate
files in .msg format.  I was surprised to find that when I did this, any
attachments came right along with the email!  I'll have to go through my
code to find this, and I'll reply again tomorrow.  

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman
Sent: Monday, April 09, 2007 2:55 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Case management and external files

Greetings All,
 
  Question: anyone done work with case management and external files (i.e
medical records, faxes, Word Docs, etc)?  I know it's always best to leave
them external, but beyond that:
 
a. Any best practices you've found for linking them to a given case - i.e.
do you tag them or place them in a per claim specific directory?
 
b. How do you handle inbound faxes?  Any recommendations on software?
 
c. What about e-mails with attachments?  Manual operation to cut/save the
attachment or something more automatic?
 
  Any insights would be helpful.
 
Thanks,
Jim
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com