attaching a word doc to a record.

[Guest]

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

 

[Guest]

Check out Hyperlink fields. I'd think that it would be more efficient to
store the graphics in some graphic file format though.

 

[Guest]

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

 

[Phillip Windell]

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.