KB Article 198466

[Keith]

The code in this article should accomplish what I am
trying to do to save an OLE object (bmp image) in a
table. I have tested the code with eveything set up as
listed but it crashes at the statement:
[OLEFile].Action = acOLEEmbedded
and doesn't insert the image into the table. Has anyone
else tried this code? Did it work? Any solutions to make
it work? I am running Access 2002, does that make a
difference?

Thanks in advance for any input!

 

[Kevin K. Sullivan]

The code in this article should accomplish what I am
trying to do to save an OLE object (bmp image) in a
table. I have tested the code with eveything set up as
listed but it crashes at the statement:
[OLEFile].Action = acOLEEmbedded
and doesn't insert the image into the table. Has anyone
else tried this code? Did it work? Any solutions to make
it work? I am running Access 2002, does that make a
difference?

Thanks in advance for any input!

Keith,

The line you quote is not in the example. It looks like the merging of two
lines out of the following three:

[OLEFile].OLETypeAllowed = acOLEEmbedded
[OLEFile].SourceDoc = [OLEPath]
[OLEFile].Action = acOLECreateEmbed

Did you mistype?

HTH,

Kevin

 

[Keith]

Kevin,
The message was a typo and I had typed the code
correctly. I ended up with the code working when I
switched to a different directory with images. I am still
not sure why it wouldn't work with the original
directory. The only issue I could see was the the 1st
image that it tried to load was a high-rez image and it
may have choked.

Thanks for the response,
Keith

-----Original Message-----

The code in this article should accomplish what I am
trying to do to save an OLE object (bmp image) in a
table. I have tested the code with eveything set up as
listed but it crashes at the statement:
[OLEFile].Action = acOLEEmbedded
and doesn't insert the image into the table. Has anyone
else tried this code? Did it work? Any solutions to make
it work? I am running Access 2002, does that make a
difference?

Thanks in advance for any input!

Keith,

The line you quote is not in the example. It looks like the merging of two
lines out of the following three:

[OLEFile].OLETypeAllowed = acOLEEmbedded
[OLEFile].SourceDoc = [OLEPath]
[OLEFile].Action = acOLECreateEmbed

Did you mistype?

HTH,

Kevin


.