KB Article 198466

  • Thread starter Thread starter Keith
  • Start date Start date
K

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!
 
Keith said:
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!
Click to expand...


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
 
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!
Click to expand...


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


.
Click to expand...
 
Back
Top