Image extraction

[Jim Smith]

I know very little about Access but a friend who probably knows less
than I do has a database in Access 2002 that is 155MB. There are
images in the database we would like to extract, but neither of us has
an idea how to do it. I'd appreciate any pointers on how to go about
this.

[Larry Linson]

"Jim Smith" wrote

I know very little about Access but a friend
who probably knows less than I do has a data-
base in Access 2002 that is 155MB. There are
images in the database we would like to extract,
but neither of us has an idea how to do it. I'd
appreciate any pointers on how to go about
this.

How are they stored?

If they are stored as OLE Objects, then take a look at MVP Stephen Lebans'
http://www.lebans.com/oletodisk.htm. If they are stored in OLE Fields, but
not as true OLE objects, there's some code at http://accdevel.tripod.com in
the BLOB example that you might use to extract them and code to write them
to a temporary file (you can assign your own file names, rather than using a
temporary file).

If neither of these, post back here and perhaps someone can offer a
suggestion.

Larry Linson
Microsoft Access MVP

[Jim Smith]

On Sun, 19 Nov 2006 03:15:27 GMT, "Larry Linson"
<bo*****@localhost.notwrote:

>"Jim Smith" wrote

I know very little about Access but a friend
who probably knows less than I do has a data-
base in Access 2002 that is 155MB. There are
images in the database we would like to extract,
but neither of us has an idea how to do it. I'd
appreciate any pointers on how to go about
this.

How are they stored?

If they are stored as OLE Objects, then take a look at MVP Stephen Lebans'
http://www.lebans.com/oletodisk.htm. If they are stored in OLE Fields, but
not as true OLE objects, there's some code at http://accdevel.tripod.com in
the BLOB example that you might use to extract them and code to write them
to a temporary file (you can assign your own file names, rather than using a
temporary file).

If neither of these, post back here and perhaps someone can offer a
suggestion.

Larry Linson
Microsoft Access MVP

Larry:
I've muddled in the database and looking at the forms he has
in design view, there is a "frame" for an image. The name on the
window is "bound image frame: image".
I don't know if that helps.
I'll try looking at the sites you've pointed out to see if I
can figure this out. Thanks.

[MLH]

I only caught a piece of this thread, sorry. Not to overstate
the obvious, but will the images open in an editor by dbl-
clicking them? One-by-one, they could be opened this way
in an editor that you might be able to save them to disk.

[Jim Smith]

On Sun, 19 Nov 2006 10:37:52 -0500, MLH <CR**@NorthState.netwrote:

>I only caught a piece of this thread, sorry. Not to overstate
the obvious, but will the images open in an editor by dbl-
clicking them? One-by-one, they could be opened this way
in an editor that you might be able to save them to disk.

I'm not familiar with Access in the slightest sense.
My friend showed me enough to view a report with the images in
there, but we are unable to do anything much more than that.
He wants to migrate to a database system that's more user
friendly and it looks like I'll have to learn the program in order to
move him off it.

[Larry Linson]

"Jim Smith" <no******@notlikely.comwrote

I'm not familiar with Access in the slightest
sense. My friend showed me enough to view
a report with the images in there, but we are
unable to do anything much more than that.
He wants to migrate to a database system
that's more user friendly and it looks like I'll
have to learn the program in order to
move him off it.

What "database system that's more user friendly" did you friend (or you)
have in mind. I ask because, arguably, there aren't any.

IMNSHO, there certainly aren't any "more user friendly" that have as much
capability as Access. Be careful that you don't choose something that's so
easy it won't do what you need done.

Larry Linson
Microsoft Access MVP

[Larry Linson]

"Jim Smith" wrote

I've muddled in the database and looking at the forms he has
in design view, there is a "frame" for an image. The name on the
window is "bound image frame: image".

Jim, there are "Image Controls," and there are "Unbound Object Controls" and
"Bound Object Controls." Please look again, and if the Properties dialog is
not visible, click the "frame" to select it, then right-click, and choose
"Properties." In the bar at the top of the Properties dialog, read what it
says before the ":" (colon) and post back with the exact words.

But, even before you do, if that is "Bound Object Frame:", double-click the
image itself in Form view, and see if it doesn't open the image processing
software you / your user has registered for that type of image file. If it
does, then File | Save or File | Save As may work to allow you to save the
image, without going to a lot of trouble to "extract" it.

Larry Linson
Microsoft Access MVP

[Jim Smith]

On Mon, 20 Nov 2006 03:56:18 GMT, "Larry Linson"
<bo*****@localhost.notwrote:

>"Jim Smith" wrote

I've muddled in the database and looking at the forms he has
in design view, there is a "frame" for an image. The name on the
window is "bound image frame: image".

Jim, there are "Image Controls," and there are "Unbound Object Controls" and
"Bound Object Controls." Please look again, and if the Properties dialog is
not visible, click the "frame" to select it, then right-click, and choose
"Properties." In the bar at the top of the Properties dialog, read what it
says before the ":" (colon) and post back with the exact words.

But, even before you do, if that is "Bound Object Frame:", double-click the
image itself in Form view, and see if it doesn't open the image processing
software you / your user has registered for that type of image file. If it
does, then File | Save or File | Save As may work to allow you to save the
image, without going to a lot of trouble to "extract" it.

Larry:
I appreciate your patience. I've made a few more developments.
Looking at the entry forms he's made, I double click on an
image and get this message: "The Picture object doesn't support the
attempted operation. If you want to perform the operation, delete the
OLE object, and then embed or link it again."
FYI: "Properties" is grayed out when I right click.
I'm going to guess and say these are not "true OLE objects" as
you said in a previous post.