Save OLE object from within Access as .otm File

I have a new project that I am working on. Actually just more advanced within the same project.

I have the need to carry a .OTM file along with my program in order to have access email through outlook properly in Access 2003 systems.

My intention, and the way I have it setup now is the I have a hidden OLE object on my form (Which is the .OTM file). I now have it set up to make visible then copy...

Here is the problem. I can not get it to copy to the folder. I know which folder, how to call it, etc.

What I really want to do is export the .OTM (without opening it...Since this seems to make it not work properly.) to the proper folder as the proper name. I have it packaged and opening package manager the save as...Works without a problem. ALso, manually copy and pasting the object from Access to the correct folder works as well. HOW DO I AUTOMATE IT??

Any help is greatly appreciated as always. If anyone wants to see the code I have please just ask. I didnt feel it useful since the steps I need I have no code for.

Thanks Again.

Nick

re: Save OLE object from within Access as .otm File

Hello, Nick.

What about storing the files as BLOBs.

Regards,
Fish

re: Save OLE object from within Access as .otm File

Fish,

It is not an image...Will it still work? The file is from Outlook vba. It is VbaProject.OTM, Basically a .txt file but not quite. DO you think this would still work?

Thanks,
Nick

re: Save OLE object from within Access as .otm File

Nick.

BLOB (aka OLE in Access) field simply stores a large array of bytes.
No matter the way array was obtained and what it does contain.

BLOBing files (no matter what they are) is so common procedure that ADO lib from version somewhat about 2.5 (don't know exactly) supports Stream object to make it as easy as possible.

As for the article - it was mostly all about rendering stored images on form which is far more tricky task then simple file uploading/downloading.

Regards,
Fish

re: Save OLE object from within Access as .otm File

Sorry for the late reply. That worked perfectly. Thank you for your assistance with this issue.

Nick

re: Save OLE object from within Access as .otm File

You are welcome, Nick.

Best regards,
Fish