CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2002
    Location
    Piscataway, NJ, USA
    Posts
    23

    OLE Object Field Copy to another Access Table

    Hi,

    I have the following code to copy fields into another Access Database Table. I am having hard time to copy teh OLE Object field which contains image information.

    MySqlText = "INSERT INTO BackupTable (OriginalID, Image1) VALUES(" & de1.rsOriginal("ID") & ", '" & de1.rsOriginal("Image1") & "');"

    Image field is the OLE Object field

    Could anyone tell me how to copy OLE Object fields from one table to another?

    Thanks
    Logic is the future...

    leokoach.com

  2. #2
    Join Date
    Mar 2013
    Location
    Neteherlands
    Posts
    3

    Re: OLE Object Field Copy to another Access Table

    Hi, I have the same problem. Did you find a solution for this?
    Regards, Paul.

  3. #3
    Join Date
    Jan 2006
    Location
    Fox Lake, IL
    Posts
    15,007

    Re: OLE Object Field Copy to another Access Table

    Really? 11 years later? Please don't revive old posts.
    David

    CodeGuru Article: Bound Controls are Evil-VB6
    2013 Samples: MS CODE Samples

    CodeGuru Reviewer
    2006 Dell CSP
    2006, 2007 & 2008 MVP Visual Basic
    If your question has been answered satisfactorily, and it has been helpful, then, please, Rate this Post!

  4. #4
    Join Date
    Mar 2013
    Location
    Neteherlands
    Posts
    3

    Re: OLE Object Field Copy to another Access Table

    Quote Originally Posted by dglienna View Post
    Really? 11 years later? Please don't revive old posts.
    Well, apparently no-one had a solution for this, so it is not a trivial question. As you're an (ex)MVP, it must be very simple to answer this question instead of reacting like this...

  5. #5
    Join Date
    Mar 2013
    Location
    Neteherlands
    Posts
    3

    Re: OLE Object Field Copy to another Access Table

    Sorry, only now I see you include some links. Thanx, I will study them!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured