Results 1 to 10 of 10
  1. #1
    Join Date
    Jun 2008
    Posts
    4

    Unanswered: ole object field

    Hi
    I am using ms office proffessional 2003.I have a database in access and nearly all the pics were embedded when I got it. I have to insert the new pics to the
    Olebject field. I do insert object ->create from file and then browse the name of .jpg picture. But what I see is just the name of the pic on the forms view. I tried to google and solutions said that there is need to install photo editor.
    But I have full office installed and it comes with picture manager instead.

    Please help me out through the problem.

    Thanks
    Sunjain

  2. #2
    Join Date
    Aug 2006
    Posts
    559
    Why aren't you just doing --> Insert -> Picture -> From File

  3. #3
    Join Date
    Jun 2008
    Posts
    4
    In MS office access i just find 2 options 1) create from file --we browse the .jpg file and next is 2)Create New -- we create the new bit map there itself.

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Dare I ask how many pictures exist already?

    I ask because it's a much better practice to only store the path to the picture file rather than embed pictures throughout the data file as it tends to cause massive files and leads to file corruption.

    Depending on how the database was created, you may have to paste the picture in *shudder*
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  5. #5
    Join Date
    Aug 2006
    Posts
    559
    Quote Originally Posted by StarTrekker
    Dare I ask how many pictures exist already?

    I ask because it's a much better practice to only store the path to the picture file rather than embed pictures throughout the data file as it tends to cause massive files and leads to file corruption.

    Depending on how the database was created, you may have to paste the picture in *shudder*
    I do that but its ONLY for like form backgrounds, nothing else. The last DB that I made had an OLE Object which you could upload a PDF to. But they were stored in a separate folder on the network share with the back-end.

    So you going to make fun of me Trekk?

  6. #6
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Not at all 'Fix

    I've done similar in the past, but the file got only to 100MB and started self corrupting within one month of use. One of my early efforts

    Anyway, no I was referring to using the "paste it in" method as a possible solution to your problem. If you can't choose Insert - Object, try copying the picture to the clipboard and then selecting your OLE object and choose Paste! You could try it by copying the picture file and you can try it by opening a picture, selecting its content and then pasting. Have a shot and see if it works
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  7. #7
    Join Date
    Jun 2008
    Posts
    4
    The clipboard paste did not work and now as the things are about to finish I really can't change the way the data is stored.
    Any way if you guys find the another way please let me know.


    Thanks
    Sunjain

  8. #8
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Just out of curiosity, if you try to copy and paste a .BMP versus a .JPG file, does it work?
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  9. #9
    Join Date
    Jun 2008
    Posts
    4
    hi

    .bmp files worked man. Strange ! but nyways thanks a ton.

  10. #10
    Join Date
    Aug 2006
    Posts
    559
    Quote Originally Posted by sunjain
    hi

    .bmp files worked man. Strange ! but nyways thanks a ton.

    If I'm not mistaken, bmp files are like native to MS stuff??

Posting Permissions

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