Icon in stead of image

[Guest]

I have stored a bmp image in a SQL Server 2000 image-field, but when I try to
show it using a bound object frame (DisplayType=content) on a Access 2002
Project Form it is shown as an icon in stead of an image.

I understand that you don't need any special installed graphic filer for
bmp-files.

What's wrong?

 

[Larry Linson]

I have stored a bmp image in a SQL Server 2000 image-field, but when I try
to
show it using a bound object frame (DisplayType=content) on a Access 2002
Project Form it is shown as an icon in stead of an image.

I understand that you don't need any special installed graphic filer for
bmp-files.

You shouldn't need any special filters for .BMP.

Your image must be stored as an OLE Object in order to be displayed in a
Bound Object Frame... there's example code for doing so in Access (which
should probably work on a linked table in SQL Server, but may not work
without modification in an Access project) in the downloadable imaging
examples at http://accdevel.tripod.com.

Your display of the image can also be affected by whatever software is
registered for the image type, and many image processing software suites
just arbitrarily reassign graphic file types to themselves.

Larry Linson
Microsoft Access MVP

 

[Guest]

Thanks,

The image is of course stored in an OLE Object datatype format in the table
and it works fine using Access 2000, but not in Access 2002 and 2003. I also
tried using an Access 2000 database instead of the SQL Server database. It's
the same problem.

If I open the table in the Access 2000 databas where it is stored and look
in the OLE Field of the new record that I just stored it says 'Package'. If I
look in older records previously stored in erlier versions of Access it says
'Paintbrush Pictures' or 'Bitmat Image'. If I then open my form the
'Paintbrush Pictures' or 'Bitmat Image' records show the image but the new
'Package' record only shows and icon.

When inserting a new image I use the Action property of the Bound Object
Fiels, i.e.
Me!BildOLE.Action = acOLEInsertObjDlg
and browse to a bmp-file on the disk.

/Lars

 

[Guest]

I am gettting the same problem since I "upgraded" to access 2003 from 97.
Bitmaps which were inserted when I was using 97 are fine - they are stored as
bitmaps and display correctly. However, any bitmaps added since are stored as
Packages and display as Icons with the filename. This occurs even if I copy
the bitmap into the table directly using copy/paste and open (actually the
menu option is now "activate") the Package from the table directly.

I don't have any fancy image packages installed, which might try to take
over responsibility for .bmps so bitmaps open with the Microsoft Office
Picture Manager.

In Hope

 

[Guest]

Hi Pete,

I am glad that you posted this problem, because I have not yet found any
answer to it. So we can wait together for someone at Microsoft to acknowledge
this problem and post us a solution.

/Lars

 

[bob]

I don't have any fancy image packages installed, which might try to take
over responsibility for .bmps so bitmaps open with the Microsoft Office
Picture Manager.

Some 'fancy image package' has taken over responsibility for .bmp's - namely Office Picture Manager. This
application does not support the OLE interfaces required for displaying bmp's in a bound object frame.
Set the .bmp association to 'Paint' and it should start working again.