huBelial
asked on
OLE datatype
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?
When storing it by drag-and-drop, the extraction resulted in blank images.
It extraction works fine when I store the images programmatically.
Whats the difference? Are they stored different? Are there any conversion involved?
When storing it by drag-and-drop, the extraction resulted in blank images.
It extraction works fine when I store the images programmatically.
ASKER
I understand but I still want to know why its doing that.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I retrieve the images programmatically so the double-click doesn't really apply in my case.
You asked
<So if I drag and drop an image into an OLE datatype column, the image will be stored as a package.>
I explained :)
OLE Filters and servers are fussy things. When you do it programmatically these are mostly bypassed or controlled.
<So if I drag and drop an image into an OLE datatype column, the image will be stored as a package.>
I explained :)
OLE Filters and servers are fussy things. When you do it programmatically these are mostly bypassed or controlled.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Don't use OLE data types.
Don't use the new-fangled attachment types either.
Store your images in folders, save the path in a table and use the .Picture property of Image controls to use them
Google it. Nobody recommends what you are attempting.
http://www.jamiessoftware.tk/articles/handlingimages.html