Acekid09 said:
I currently have an access DB set up with many records. Each record has
some
associated word or excel files. I was wondering if there was anyway to
link
these files to my access DB record. Can you save these files or paste them
to
the record in access? Please help!!
The sample imaging databases at
http://accdevel.tripod.com illustrate three
approaches to handling images in Access, and the download includes an
article discussing considerations in choosing an approach. One of the
approaches stores the image file as a BLOB (Binary Large OBject) in an OLE
Object field -- and, the technique is not limited to image files. There is
code in the example showing how to accomplish exactly what you ask.
You've already received advice on storing the address as a hyperlink, but
another example in the referenced example shows saving the path and file
name of an external file as text. You can do a similar thing storing the
path and file name as text and using the .FollowHyperlink -- which is nicely
covered in Help.
Best of luck with your project.
Larry Linson
Microsoft Office Access MVP
Larry Linson
Microsoft Office Access MVP