"Embed" Word or other files within a database

[Juan]

Hi everyone

I know it's possible to use Access to create a Word document and think it's possible to have a button (or combobox) open a Word document saved on the hard drive. If I'm correct with the second belief, the Word file(s) would need to be moved with the Access database if it's moved to another directory or PC.

Is it possible to save the Word (or other) files within the database itself so simply moving the database to another directory or PC would take the "embedded" files with it? I realise that the database file size will increase, but suspect that this increase would be similar to the size of the individual Word files.

Thanks for your time.

 

[ghudson]

Your db will quickly bloat by adding files of any type. You should store the path to the file but you can set the path to always begin with the location of the db by using the CurrentProject.Path property to get the database path.

 

[Juan]

I guessed that would be the way to do it. I just wanted to avoid having to copy associated files if I copy the db. I suppose I could keep just the db and these files in a specific directory and then copy the directory elsewhere.

Thank you for the advice.