Linking attachments

[Obeng]

I'm working with an access 2010, I have an attachment field, after you attach file it appears the attachment is embedded in the access database itself, bloating it's size. I was wondering if there is a way to link the attachments without embedding it in the database.

Thank you

 

[Beetle]

You can just store the path to the file in a text field and open it from, for example, a command button on a form using -

Application.FollowHyperlink "PathNameHere"

- in the Click event of the button.

 

[GT_engineer]

I need to learn how to put attachments from pictures to PDF files onto a form. I want them to be linked to keep size of the database a minimal.

I want users to select an attachment from their HD and it gets saved to a network drive, that way everyone has access to the file and we don't have to worry about broken links.

How do I do this??