Save OLE object from within Access as .otm File

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • nspader
    New Member
    • Mar 2008
    • 78
    #1

    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
    Tags: None
    • FishVal
      Recognized Expert Specialist
      • Jun 2007
      • 2656
      #2
      Hello, Nick.

      What about storing the files as BLOBs.

      Regards,
      Fish

        Comment

        • nspader
          New Member
          • Mar 2008
          • 78
          #3
          Originally posted by FishVal
          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

            Comment

            • FishVal
              Recognized Expert Specialist
              • Jun 2007
              • 2656
              #4
              Originally posted by nspader
              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

                Comment

                • nspader
                  New Member
                  • Mar 2008
                  • 78
                  #5
                  Originally posted by FishVal
                  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

                    Comment

                    • FishVal
                      Recognized Expert Specialist
                      • Jun 2007
                      • 2656
                      #6
                      You are welcome, Nick.

                      Best regards,
                      Fish

                        Comment

                        Previous template Next
                        Working...