A2K How to insert a bitmap correctly?

I want to insert a bitmap from file.
I tried to do it with appendchunk.
The result is that I see only "Long Binary Data" in the Ole-field of
the table and I can't view the content.

I guess that I have to tell the routine the file type as it is done if
I insert a bitmap manually (or Excel worksheet etc.).
So how to do it?

Is there another way using DLLs?
What would be the Declares?
Is there an example out?

Regards
Juergen

In (a rather old) document accompanying an example database I created and
posted, I found the following:

"At the Microsoft web site, http://support.microsoft.com,
you can find the Access Knowledge Base. Article Q158941,
"ACC: How to Load OLE Objects from a Folder into a
Table" is worthwhile reading on this subject. It shows the
properties of the bound OLE control that you should set.
However, because I could not determine the class of the
JPG image file that I was loading, I omitted that and it
seems to work quite well without setting the Class property."

You'll find the imaging example database at http://accdevel.tripod.com. I
have tested none of those examples with recent versions of Access... so they
may well not work properly with Access 2007 or 2010.

To store the image file as an OLE object, you have to 'wrap' it with some
additional control information for OLE. If you examine my example, you'll
see that you stored it as a Binary Large Object, even though you saved it in
an OLE field.

Larry Linson, Microsoft Office Access MVP
Co-Author, "Microsoft Access Small Business Solutions", Wiley, 2010


Jürgen Meyer" <juergen.ul.meyer (AT) gmx (DOT) de> wrote

Hi Larry,

tnx für reply
Quite sure it will help

rgds
Juegen