Attached Word Documents

  • Thread starter Thread starter JF Bouthillier
  • Start date Start date
J

JF Bouthillier

Hi all,

Can someone tell me what is the best way to have Word
documents and pictures bounded to an Access DB. Should I
use OLE objects or is there another option?

I am hoping to reduce effort required from the users and
the system admin.

Thank you.
JF
 
Hi JF

I think it is better to store images and complex documents (Word, Excel,
etc) as separate files. They will take up far more space if you store the
data in your tables, and this will cause database bloat and increase the
risk of corruption.

You can either store the full file path in a text field in your table, or
you can define a "root" path, either relative to the CurrentProject.Path or
stored in a "Settings" table. Then your file paths are assumed to be
relative to that root.

You can load images from files into an image control on a form for viewing,
or you can launch the associated application (Word, Excel, etc) to view a
document.
 
Back
Top