I have a word document that i would like to attach to each record. Is it
possible to do this. Would doing this make my database slow, as each doc has
1-5 pictures in it?
thanks in advance.
BBR

Check out Hyperlink fields. I'd think that it would be more efficient to
store the graphics in some graphic file format though.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"BBR" wrote:

> I have a word document that i would like to attach to each record. Is it
> possible to do this. Would doing this make my database slow, as each doc has
> 1-5 pictures in it?
> thanks in advance.
> BBR

How would I go about attaching the picture to each record. I tried to use
the hyperlink function and I don't think I am doing this correctly.
Do I need to create a subtable to my main table and attach the picture
within that subtable???
thanks

Store the path (not the hyperlink) to the image in the DB. Store the path in
one field of the Table and store the image file name in another field. Don't
store the image itself in the DB. If you use a relative path then it should
be fine if the whole thing gets moved to a different machine. A Hyperlink
(if you need one later) can be dynamically built from the "path" retrieved
from the DB.

The function AppPath() will return the root Path of the Application. you
then concatenate all three together to create the full path to the image
file.

AppPath() & strPath & strImageFileName

If you didn't need the full path, you could get a relative path like this:

strPath & strImageFileName

BTW - that isn't exact code,..it is just to give you an idea of how to
proceed.

--
Phillip Windell [MCP, MVP, CCNA]
www.wandtv.com


"BBR" <(E-Mail Removed)> wrote in message
news:798FB2DE-E426-4B43-A660-(E-Mail Removed)...
> How would I go about attaching the picture to each record. I tried to use
> the hyperlink function and I don't think I am doing this correctly.
> Do I need to create a subtable to my main table and attach the picture
> within that subtable???
> thanks