Results 1 to 12 of 12
  1. #1
    2 Star Lounger
    Join Date
    May 2002
    Posts
    113
    Thanks
    0
    Thanked 0 Times in 0 Posts

    OLE Pictures in Access (Access2003)

    I've created an "employee picture" OLE (data type) table field and tried to Insert various types of Objects (Pictures); .bmp, .jpg, .gif etc. I know Paint is working good and recognizes, converts and opens these pictures but when I insert them into the "Employee Picture" field cell, all I get is the word "Package". Of course, when you put this on a form it only shows a .jpg or .bmp icon; no picture. Any ideas or answers are really appreciated in advance. Thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: OLE Pictures in Access (Access2003)

    It is not a very good idea to store images in an OLE field. It will cause your database to grow tremendously in size, for Access stores an uncompressed bitmap of each image. The recommended approach is to store the path and filename of the image in a text field in the database, and to use a standard image control (not an unbound OLE control) and some VBA code to display the image. The database attached to <post#=296892>post 296892</post#> demonstrates how to do this in a form and in a report. The images can be .bmp, .jpg, .gif, .png, .wmf, .tif and several other graphics formats.

  3. #3
    2 Star Lounger
    Join Date
    May 2002
    Posts
    113
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: OLE Pictures in Access (Access2003)

    Thanks Hans for the quick reply. My dilema is this. I teach a basic Access course (read: NO VISUAL BASIC PROGRAMMING) at a local community College. Prior to Access 2003, there really wasn't a problem using the OLE Data Type as long as Access was fully installed. Therefore, a couple of questions; (1) Does this effectively render the OLE Data Type useless? (2) As you suggest; do we just use the Image tool and code to make this work. (3) Is there no other simple way to make the "Employees" picture change on a form when you go from record to record (other than using VB?). As always; appreciate any info you can provide.
    Bob W.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: OLE Pictures in Access (Access2003)

    Storing images in an OLE field has always been a bad idea, in all versions of Access. But the method I mentioned really requires VBA coding, although not much. If you're teaching basic Access, you could mention this, and refer to a course including VBA for the details.

    About the problem with images being displayed as a package, there are some things you can try to remedy it (for it is not normal behavior):
    - Reinstall MS Paint (from your Windows CD)
    - Perform a repair installation of Access/Office, in particular the graphics filters (no need to reinstall Office as a whole)

  5. #5
    4 Star Lounger
    Join Date
    Aug 2003
    Location
    Stroud, United Kingdom
    Posts
    548
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: OLE Pictures in Access (Access2003)

    Hi Hans,

    you say in your post that .tif images are supported, however this is not the case for me. Access 2003, but .tif files do not work. In your ddemo db the filter does not include .tif, and if i choose all files and try to insert a .tif i get the error : Microsoft Office Access doesn't support the format of the file xxxxx.tif, or file is too large. Try converting to bmp/jpeg etc.

    any thoughts?
    Thanks,

    pmatz

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: OLE Pictures in Access (Access2003)

    I am on Access 2002 at the moment, I just tried to insert a .tif file and it worked without problems. Perhaps the conversion filter for .tif hasn't been installed on your PC?

  7. #7
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: OLE Pictures in Access (Access2003)

    That's intersting Matz.

    I saw this on the MS site

    Access 2K3 default installs Have I got the wrong end of the stick here, but it states that TIFF formats can be imported <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Jerry

  8. #8
    4 Star Lounger
    Join Date
    Aug 2003
    Location
    Stroud, United Kingdom
    Posts
    548
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: OLE Pictures in Access (Access2003)

    Hmmm, just reinstalling Office 2003 with all features... (except Infopath [img]/forums/images/smilies/wink.gif[/img])....

    ...nope

    still wont insert tif to view. When I go Insert Picture, it gives me the preview on the dialog box, but when i inert just an empty box.

    no way
    Thanks,

    pmatz

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: OLE Pictures in Access (Access2003)

    It seems the TIF filter is not installed with Access 2003 any more, and that you can ask Microsoft to send you the XP converter pack. See this newsgroup thread.

  10. #10
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: OLE Pictures in Access (Access2003)

    Matz

    In addition to Hans' post, it appears Stephen Leban has been on a few forums answering this problem:

    "The Tiff Office Graphics filters(among others) are not installed with Access 2003. This is a change from all previous versions of Access.
    The solution is to get hold of the Office XP Legacy Converter Pack (it will work for Office 2003 as well). The problem is that you can no
    longer download the XP Converter Pack due to security concerns."
    Jerry

  11. #11
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: OLE Pictures in Access (Access2003)

    Umm, that is in the newsgroup thread I posted a link to...

  12. #12
    4 Star Lounger
    Join Date
    Aug 2003
    Location
    Stroud, United Kingdom
    Posts
    548
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: OLE Pictures in Access (Access2003)

    Thanks for this Hans and Jezza. I wonder why MS did this to Access!? All the other 2003 applications can display the .tif images no problem.

    I will try to find said download and sort this.
    Thanks,

    pmatz

Posting Permissions

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