How do I attach pdf and excel files to records/forms in Access?

[Guest]

I would like to add and attach files from My Documents to individual records
in an order entry database so that we can look at releated quotes, images
etc. when in order edit/inquiry mode

 

[Jason]

I am trying to do the same thing. If you get an answer can you please
let me know. If I find out I will let you know as well.

 

[Pat Hartman\(MVP\)]

Since it sounds like you want to attach multiple documents, create a new
table with four columns:

tblAttachments:
AttachmentID (autonumber primary key)
CustomerID (foreign key to customer table - or whatever table you want to
link the attachments to)
AttachmentType
AttachmentAddress - this can be a full path or it can be a hyperlink. I
would not embed the documents. Access tends to bloat when it holds OLE
objects. The next version of Access will have some good features in this
area but that's nearly a year away.

 

[Guest]

Pat,

thank you for your reply. I will try that and see how it works for our
applications.

Thanks again!

Roland