[AccessD] Case management and external files

I do the same.  Outlook has a collection to hold messages.  Each message has
a collection to hold attachments.  You can iterate these collections storing
the objects as you wish.  I "strip off" attachments all of the time simply
by iterating the attachments collection and doing a save of the items. 

John W. Colby
Colby Consulting
www.ColbyConsulting.com

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


Regarding the attachments in emails: as has been pointed out, when you save
such emails as .msg files the attachments are included.

Regarding preventing the pesky users from damaging the stored files: I store
the files somewhere on the network and the users get at the files via an
Access app. When they select a file to examine the Access app *copies* the
original to a predefined folder on the user's home drive, and then opens the
copy for them to play with. When the Access application shuts down, any
files found in the predefined folder are deleted.

HTH

Lambert

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman
Sent: Monday, April 09, 2007 3: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
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com