473,549 Members | 2,616 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Converting Access OleObject images back into native format

I have an Access database/forms application that has images stored in
it. I need to develop a new VB that utilizes Oracle or the file
system as the underlying storage for these images. In order to do
this I need to retrieve and save the images to disk in their native
format.

The problem is that the images are stored in Access as the OleObject
type rather than binary. I cannot figure out how to pull these
imagesfrom the database and store them in their native format such
that double-clicking the file will launch the associated application.

I've read a lot of threads about moving images in/out of Access
databases but the resulting files never seem to be in their native
format. Please advise.

-Rich
Nov 12 '05 #1
4 6780
Sounds like you need to visit Stephen Lebans's website.
www.lebans.com

Larry Linson may have some info on how to do it, but I'd bet Stephen
has code, if anyone does.
Nov 12 '05 #2
Have you looked here:
http://www.lebans.com/oletodisk.htm
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"RichG" <pi********@hot mail.com> wrote in message
news:73******** *************** ***@posting.goo gle.com...
I have an Access database/forms application that has images stored in
it. I need to develop a new VB that utilizes Oracle or the file
system as the underlying storage for these images. In order to do
this I need to retrieve and save the images to disk in their native
format.

The problem is that the images are stored in Access as the OleObject
type rather than binary. I cannot figure out how to pull these
imagesfrom the database and store them in their native format such
that double-clicking the file will launch the associated application.

I've read a lot of threads about moving images in/out of Access
databases but the resulting files never seem to be in their native
format. Please advise.

-Rich


Nov 12 '05 #3
Hi Stephen,

Thanks for the quick reply. I found the site a little while ago, but
I dont think I investigated it deep enough. Does it matter that the
image that we are trying to extract is not a bitmap (they are some
sort of Paint Shop Pro v5 and v7 files as well as some "packages") .
How could I modify it to extract these types?

Thanks again,
-Rich
"Stephen Lebans" <Fo************ *************** *************@l invalid.com> wrote in message news:<vt******* ************@ur sa-nb00s0.nbnet.nb .ca>...
Have you looked here:
http://www.lebans.com/oletodisk.htm
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"RichG" <pi********@hot mail.com> wrote in message
news:73******** *************** ***@posting.goo gle.com...
I have an Access database/forms application that has images stored in
it. I need to develop a new VB that utilizes Oracle or the file
system as the underlying storage for these images. In order to do
this I need to retrieve and save the images to disk in their native
format.

The problem is that the images are stored in Access as the OleObject
type rather than binary. I cannot figure out how to pull these
imagesfrom the database and store them in their native format such
that double-clicking the file will launch the associated application.

I've read a lot of threads about moving images in/out of Access
databases but the resulting files never seem to be in their native
format. Please advise.

-Rich

Nov 12 '05 #4
It will work for any Image file format that you can see a preview for
within a Bound/Unbound OLE Frame control.
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"RichG" <pi********@hot mail.com> wrote in message
news:73******** *************** ***@posting.goo gle.com...
Hi Stephen,

Thanks for the quick reply. I found the site a little while ago, but
I dont think I investigated it deep enough. Does it matter that the
image that we are trying to extract is not a bitmap (they are some
sort of Paint Shop Pro v5 and v7 files as well as some "packages") .
How could I modify it to extract these types?

Thanks again,
-Rich
"Stephen Lebans"

<Fo************ *************** *************@l invalid.com> wrote in
message news:<vt******* ************@ur sa-nb00s0.nbnet.nb .ca>...
Have you looked here:
http://www.lebans.com/oletodisk.htm
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"RichG" <pi********@hot mail.com> wrote in message
news:73******** *************** ***@posting.goo gle.com...
I have an Access database/forms application that has images stored in it. I need to develop a new VB that utilizes Oracle or the file
system as the underlying storage for these images. In order to do
this I need to retrieve and save the images to disk in their native format.

The problem is that the images are stored in Access as the OleObject type rather than binary. I cannot figure out how to pull these
imagesfrom the database and store them in their native format such
that double-clicking the file will launch the associated application.
I've read a lot of threads about moving images in/out of Access
databases but the resulting files never seem to be in their native
format. Please advise.

-Rich


Nov 12 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
3875
by: vad | last post by:
Hi! I am new to asp and here is my question. I have an MS Access datacase,In one table I stored all the information regarding one truck, including 4 images for each of the truck.The data type for images are OLEObject. I am sending the information into the table using MS Access Form.and the images using insert object.Now the problem is...
3
3471
by: Dalan | last post by:
At first I was not certain what could cause Access 97 from displaying most jpeg images, but not all. After further testing, it seemed that all original images of less than 275 pixels per inch or less would display, but those close to 300 pixels/inch or greater would not (MS Access cannot recognize the file format xxx.jpg). The larger, original...
7
8675
by: RCS | last post by:
Okay, a rather 'interesting' situation has arisen at a place I work: I need to convert a database from Access to something that can be used over the web. I am currently maintaining and developing a mid-sized Access database (60 tables, 25 simultaneous users). Although I've been tossing up if I should try to convert the back end to SQL...
2
1571
by: Anitha | last post by:
Hi All, How to retrieve images stored in Access database. I am storing images(jpeg) as OleObject. I want display them on my web page. I am unable to do so.Please help me I am using C# The code is as // Put user code to initialize the page here int ImgID = System.Convert.ToInt32(Request.QueryString);
61
4683
by: phil-news-nospam | last post by:
Why does SVG need a different tag than other images? IMHO, SVG should be implemented as an image type just like any other image type, allowing it to work with <img> tags, and ... here is the important part ... also work with backgrounds in other tags. I fail to see any wisdom in making SVG different than say PNG (of course the...
4
2385
by: Beginner | last post by:
How do I convert JPEG images to binary files in ASP.NET? Please advice. Thanks.
0
1636
by: ziyad | last post by:
Dear Sir, I have already Converted the image into Byte and stored in access as a oledObject.I want to Display all the images in DataList.But i dont know How to convert Byte to Image OR oleObject to Image!.I can view only 1 image in explorer using "Response.BinaryWrite("Item")" .but i need a path to give as a source attribut of...
10
8358
by: NEWSGROUPS | last post by:
I work for an organization that is migrating from Access 2000 to Access 2003. About 5 or 6 years ago we migrated from Access 97 to Access 2000 with no problem. Will I have trouble converting these already converted databases to Access 2003? We also have 2 mda's, will these convert with no problem in the mda format. We no longer have the mdb...
16
11048
by: Neil | last post by:
I posted a few days ago that it seems to me that the Access 2007 rich text feature does not support: a) full text justification; b) programmatic manipulation. I was hoping that someone might know one way or the other whether that was true or not, or could point me to an article or help text that would. What I have seen so far online and in...
0
7451
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7720
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
7959
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7473
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7810
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6044
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
3501
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3483
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1061
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.