[AccessD] Adding Attachments

Yes!
 
Look through File System Objects (FSO).  A starter on FSO is at
http://support.microsoft.com/default.aspx?scid=kb;en-us;186118.  This is
code that provides a lot of ability with file manipulation.  Files can
be copied to a permanent location on a server, and can then be re-opened
using a hyperlink to that file.  Your code will need to re-name the file
so that it is identified with the particular database record, and FSO
can do that as well.  I created a table to store these hyperlinks, since
a singe record can have more than one attachment.
 
Also, go to http://www.candace-tripp.com/access_downloads.htm and
download the Windows Common Dialog demo prepared by Candace Tripp.  (I
still appreciate Candace's work on these every time I save another
attachment.)  The Common Dialog will get the full path to a saved file,
which can then be used by FSO to move or copy files.
 
Have Fun!
Dan Waters
 
 
-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com] On Behalf Of Hollis,Virginia
Sent: Tuesday, March 11, 2003 7:51 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Adding Attachments



Is there a way to add a document as an attachment to a database? 
 
The database is used to request services. The data is entered by a
customer and sometimes the customer needs to add additional
documentation to support their request. The attachment might be a sketch
or Word file.
 
Does anyone have any idea how this might be done?
 
Virginia

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030311/ba96d9c5/attachment-0001.html>