By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,121 Members | 1,723 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,121 IT Pros & Developers. It's quick & easy.

Converting Access OleObject images back into native format

P: n/a
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
Share this Question
Share on Google+
4 Replies


P: n/a
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

P: n/a
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


Nov 12 '05 #3

P: n/a
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

Nov 12 '05 #4

P: n/a
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


Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.