Connecting Tech Pros Worldwide Forums | Help | Site Map

Converting Access OleObject images back into native format

RichG
Guest
 
Posts: n/a
#1: Nov 12 '05
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
Guest
 
Posts: n/a
#2: Nov 12 '05

re: Converting Access OleObject images back into native format


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
Guest
 
Posts: n/a
#3: Nov 12 '05

re: Converting Access OleObject images back into native format


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" <picklemann@hotmail.com> wrote in message
news:73f14985.0310271442.55680c4e@posting.google.c om...[color=blue]
> 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[/color]

RichG
Guest
 
Posts: n/a
#4: Nov 12 '05

re: Converting Access OleObject images back into native format


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" <ForEmailGotoMy.WebSite.-WWWdotlebansdotcom@linvalid.com> wrote in message news:<vtknb.3425$R13.155554@ursa-nb00s0.nbnet.nb.ca>...[color=blue]
> 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" <picklemann@hotmail.com> wrote in message
> news:73f14985.0310271442.55680c4e@posting.google.c om...[color=green]
> > 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[/color][/color]
Stephen Lebans
Guest
 
Posts: n/a
#5: Nov 12 '05

re: Converting Access OleObject images back into native format


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" <picklemann@hotmail.com> wrote in message
news:73f14985.0310280727.563ed0d0@posting.google.c om...[color=blue]
> 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"[/color]
<ForEmailGotoMy.WebSite.-WWWdotlebansdotcom@linvalid.com> wrote in
message news:<vtknb.3425$R13.155554@ursa-nb00s0.nbnet.nb.ca>...[color=blue][color=green]
> > 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" <picklemann@hotmail.com> wrote in message
> > news:73f14985.0310271442.55680c4e@posting.google.c om...[color=darkred]
> > > I have an Access database/forms application that has images stored[/color][/color][/color]
in[color=blue][color=green][color=darkred]
> > > 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[/color][/color][/color]
native[color=blue][color=green][color=darkred]
> > > format.
> > >
> > > The problem is that the images are stored in Access as the[/color][/color][/color]
OleObject[color=blue][color=green][color=darkred]
> > > 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[/color][/color][/color]
application.[color=blue][color=green][color=darkred]
> > >
> > > 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[/color][/color][/color]

Closed Thread