We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

OLE datatype

huBelial
huBelial asked
on
Medium Priority
40 Views
Last Modified: 2016-05-16
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.
Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2014

Commented:
You stand upon the brink of great and painful evil.
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

Author

Commented:
I understand but I still want to know why its doing that.
CERTIFIED EXPERT
Most Valuable Expert 2014
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
CERTIFIED EXPERT
Most Valuable Expert 2014
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
I retrieve the images programmatically so the double-click doesn't really apply in my case.  
CERTIFIED EXPERT
Most Valuable Expert 2014

Commented:
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.
Jeffrey CoachmanMIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.