Embedded OLE Objects

[nutmeg]

I have been given a small database, 98 records only, but item record has a
Microsoft Photo Editor 3.0 Photo imbedded into each picture as a result this
very small database is 940 Mgs in size and will not compact down to anything
smaller. I want to get the pictures out and put them some place else and I
believe the best way once I get them out is to link them back instead of
imbedding, would that be correct, unfortunately, can't seem to find the
proper way to get them extracted from each record, copying doesn't work, they
go out as 'scrap'.

Can anyone help me with this.
Thanks,
IEJ

 

[John Nurick]

Hi IEJ,

The official way of doing this seems to be
1) use a BoundObjectFrame control on a form
2) write VBA code to step through the form's recordset and, for each
record
3) tell the control to activate the embedded object (in its parent
application)
4) automate the parent application to save the file.

There's antiquated code (Access 95/Word 6) at
http://support.microsoft.com/?id=132003 showing the general idea.

For more elegant approaches, see http://www.lebans.com/oletodisk.htm