Attachment Issues

[Pawtang]

Hi all,



I'm wondering what's considered best practice for including attachments in a database. I'd assume attaching files using the built-in attachment option would bog down the database, since it would create a copy and store it in the DB. Is this correct? I've heard whispers of some better way, some way that involves linking a record to a location on a network drive such that Access can directly open a file without storing that file in its database.

[kd2017]

Just have a field to store the file's path and filename.

You can usually use followhyperlink to open the file. If necessary you can open the file using a call to the shell.

Fyi here's an example of how to use the File Dialog box to let the user pick a file and return the path as a string: https://www.automateexcel.com/vba/open-file-dialog/

[mike60smart]

The attached is one way of doing this