By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,731 Members | 1,129 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,731 IT Pros & Developers. It's quick & easy.

Save OLE object from within Access as .otm File

P: 78
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
Sep 17 '08 #1
Share this Question
Share on Google+
5 Replies


FishVal
Expert 2.5K+
P: 2,653
Hello, Nick.

What about storing the files as BLOBs.

Regards,
Fish
Sep 17 '08 #2

P: 78
Hello, Nick.

What about storing the files as BLOBs.

Regards,
Fish
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
Sep 17 '08 #3

FishVal
Expert 2.5K+
P: 2,653
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
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
Sep 17 '08 #4

P: 78
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
Sorry for the late reply. That worked perfectly. Thank you for your assistance with this issue.

Nick
Oct 1 '08 #5

FishVal
Expert 2.5K+
P: 2,653
You are welcome, Nick.

Best regards,
Fish
Oct 1 '08 #6

Post your reply

Sign in to post your reply or Sign up for a free account.