Embedding Word into Access

[carpetbelly]

I have a form that's linked to a table. I'd like to add in a section onto the form where I can save word documents (displayed as icons) which are embedded into the table in the appropriate record. I've tried searching around to no avail on how I would achieve this. Anyone got any ideas? Thanks

 

[Remou]

It is generally a bad idea to store files in Access in version before 2007, because it causes bloat. The usual solution is to save the path to the file, rather than the file itself. Do you need to store the file?

 

[carpetbelly]

Well, it would be handier to store them but not strictly necessary. I suppose I could just store it as a hyperlink and store the documents somewhere else, but there's a chance I might have to send this on where the documents would need to be stored. I personally would avoid internal storing and have said this, but hey, gotta love jobs where people ignore your opinions.

 

[Remou]

Some references:

http://support.microsoft.com/kb/103257

http://www.codeproject.com/cs/database/AccessBlob.asp

http://www.developerfusion.co.uk/show/5658/

Or had you intened using an OLE field?

 

[fneily]

Or upgrade to Access 2007. You can store attachments in the tables.