OLE column

[huBelial]

I have a question about using the OLE datatype in Access 2007. So if I drag and drop an image into an OLE datatype column, the image will be stored as a package. But when I create a program and store an image into an OLE datatype column programmatically, the image will be stored as long binary data.

Whats the difference? Are they stored different? Are there any conversion involved?

Thank you

[ajetrumpet]

not really sure. what's the display in the table actually show?

[huBelial]

It says package if I insert images programmatically.
And long binary data when I click and drag the image.

[ajetrumpet]

what's the dif when you extract it?

any difference? that's what I was getting at. the name that it display means absolutely nothing until you figure out how that configures into working with the stuff inside of the record field.

[huBelial]

When storing it by click-and-drag, the extraction resulted in blank images.
It extraction works fine when I store the images programmatically.

[ajetrumpet]

interesting stuff. what's your extraction tool?

I've used OLE before, but it's been so long that I can't really talk intelligently about this.

obviously if it works via programming it in, then I would stick with that. right?

[huBelial]

Yeah, but I'm just curious to why it doesn't work when you drag and drop. I think the image gets corrupted somehow, I don't know

[ajetrumpet]

no idea. I'm out of it at this point. I have nothing else to offer. good luck!