Question Embed documents

[theKruser]

I am trying to embed MS Word and Excel documents into my DB to help with distribution and maintaining format. Ultimately, I would like to have a "documents" switchboard listing all the printable forms. Any help would be greatly appreciated. Thank you.

 

[DCrake]

Simple Software Solutions

As a rule, and often quoted, it is far better to have links to files instead of embedding them, as they can have a dramatic effect on the size of the mdb. If this is a must, then I suggest you create a new mdb with the table that contains the embedded files in. This table should contain 5 fields

PK
Short description of the embedded file
The actual file name including extension
The destination path
the OLE long binary data field

This table should then be linked to your front end mdb. By using Blob To File And File To Blob you will be able to store them as embedded objects into your table.

The FileToBlob function converts and stores the document as an OLE object in your database, whereas the BlobToFile function reverses the process and converts the embedded object as file in the specified destination path as the speficied name - see above.

If you need any help on the Blob functions let me know.

CodeMaster:

 

[motleyjew]

I'd be interested in seeing some of these functions if you have the time.

Thanks
Gregg