Attachments

[Henley12]

I am needing to attach pdf documents to records in my database. I have looked into the Attachment function of 2007 database, but it actually stores the records in the database, thus enlarging the database. Surely there is a way to have a link to any pdf documents I want to attach to a particular record. Has anyone accomplished this?

 

[ghudson]

Just store the location of the pdf file in a field within the record. Do you want the users to be able to browse to the pdf and store the location of where they find the file with the record?

 

[RuralGuy]

ghudson,
Glad to see you back and posting!

 

[ghudson]

ghudson,
Glad to see you back and posting!

Thanks Allan. Glad to be back and working more with Access compared to what I was doing for the past few years.

 

[odin1701]

Just store the location of the pdf file in a field within the record. Do you want the users to be able to browse to the pdf and store the location of where they find the file with the record?

Yup. Except the only issue is if someone moves them.

 

[ghudson]

Yup. Except the only issue is if someone moves them.

No way to prevent that but you can at least test in code if the file exists where you expect it to be using the Dir() function.

Check out my Browse [Find a directory or file] sample db to see how to obtain the location of a file when selected [browsed] and then store that value in your record.