Converting Access OleObject images back into native format

[RichG]

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

[Pieter Linden]

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.

[Stephen Lebans]

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********@hotmail.com> wrote in message
news:73**************************@posting.google.c om...

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

[RichG]

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****************************************@linval id.com> wrote in message news:<vt*******************@ursa-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********@hotmail.com> wrote in message
news:73**************************@posting.google.c om...

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

[Stephen Lebans]

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********@hotmail.com> wrote in message
news:73**************************@posting.google.c om...

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****************************************@linval id.com> wrote in
message news:<vt*******************@ursa-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********@hotmail.com> wrote in message
news:73**************************@posting.google.c om...

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