<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2719.2200" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=823161714-11032003><FONT color=#0000ff
size=2>Virginia,</FONT></SPAN></DIV>
<DIV><SPAN class=823161714-11032003><FONT color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=823161714-11032003><FONT color=#0000ff size=2>Since you are
storing the files externally to Access and only storing a link (path name) to
the files in Access, it makes no difference to Access what types of files they
are. Linking to external files is a frequent subject on this list so you
should be able to find a lot of hints in the archives. Some non-obvious
search terms that may help are "Image files" and "bloat."</FONT></SPAN></DIV>
<DIV> </DIV><!-- Converted from text/rtf format -->
<P><SPAN lang=en-us><B><FONT color=#0000ff>Charles Wortz</FONT></B></SPAN>
<BR><SPAN lang=en-us><FONT color=#0000ff>Software Development
Division</FONT></SPAN> <BR><SPAN lang=en-us><FONT color=#0000ff>Texas Education
Agency</FONT></SPAN> <BR><SPAN lang=en-us><FONT color=#0000ff>1701 N. Congress
Ave</FONT></SPAN> <BR><SPAN lang=en-us><FONT color=#0000ff>Austin, TX
78701-1494</FONT></SPAN> <BR><SPAN lang=en-us><FONT
color=#0000ff>512-463-9493</FONT></SPAN> <BR><SPAN lang=en-us><FONT
color=#0000ff>CWortz@tea.state.tx.us</FONT></SPAN> </P>
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Hollis,Virginia
[mailto:HollisVJ@pgdp.usec.com] <BR><B>Sent:</B> Tuesday 2003 Mar 11
08:13<BR><B>To:</B> 'accessd@databaseadvisors.com'<BR><B>Subject:</B> RE:
[AccessD] Adding Attachments<BR><BR></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=360580714-11032003>I
really do not know what I am after :-) I am open for any ideas because I sure
can't think of any...</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=360580714-11032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=360580714-11032003>Make a
folder to store the attachments and they would place them in the directory?
Would it matter if they were .pdf or .doc or any type of
file?</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=360580714-11032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=360580714-11032003>Virginia</SPAN></FONT></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Wortz, Charles
[mailto:CWortz@tea.state.tx.us]<BR><B>Sent:</B> Tuesday, March 11, 2003 7:59
AM<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> RE: [AccessD]
Adding Attachments<BR><BR></DIV></FONT>
<DIV><SPAN class=426315613-11032003><FONT color=#0000ff
size=2>Virginia,</FONT></SPAN></DIV>
<DIV><SPAN class=426315613-11032003><FONT color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=426315613-11032003><FONT color=#0000ff size=2>You can have a
hyperlink field in a table in which the link to the external document is
placed. Is this what you are after?</FONT></SPAN></DIV><!-- Converted from text/rtf format -->
<P><SPAN lang=en-us><B><FONT color=#0000ff>Charles Wortz</FONT></B></SPAN>
<BR></P>
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Hollis,Virginia
[mailto:HollisVJ@pgdp.usec.com] <BR><B>Sent:</B> Tuesday 2003 Mar 11
07:51<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> [AccessD]
Adding Attachments<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=830524313-11032003>Is there a way to
add a document as an attachment to a database? </SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=830524313-11032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=830524313-11032003>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.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=830524313-11032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=830524313-11032003>Does anyone have
any idea how this might be done?</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=830524313-11032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=830524313-11032003>Virginia</SPAN></FONT></DIV></BLOCKQUOTE></BODY></HTML>