HOW CAN I ATTACH A FILE TO BE SHOWN WITH ITS RECORD?

[KDygert]

Sorry if my question is cryptic. What I am trying to do is provide access to
a .pdf file for users of a database when they open a single record.

I am not sure what the best way to do this is. Should I create another
field to attach OLE object? Would this be easy for users to add to the
record?

 

[John Nurick]

Usually the simplest way is to leave the documents in a folder in the
file system, and just store the location of the file (e.g.
C:\folder\filename.pdf
or
\\COMPUTER\Share\Folder\filename.pdf
) in a hyperlink field.

 

[John Vinson]

Sorry if my question is cryptic. What I am trying to do is provide access to
a .pdf file for users of a database when they open a single record.

I am not sure what the best way to do this is. Should I create another
field to attach OLE object? Would this be easy for users to add to the
record?

The simplest way would probably be to store a Hyperlink to the
external .pdf file in the record. Then the user could simply click on
the field to open the viewer.

John W. Vinson[MVP]