Harold see:
http://www.lebans.com/oletodisk.htm
NEW - Apr. 14/2002 A2KExportOLEtoJPEG.zip A2K ONLY! This version
saves the entire contents of a table containing OLE Object Images to
disk based Jpeg files. User selectable compression rate. Version 1.5
Use the A2KExportOLEtoJpeg above instead of these following older
versions!
SaveOLEtoBitmap.zip is a database containing functions to allow you to
save the contents of an OLE Field to a disk based Bitmap file.
SaveOLEtoBitmapAuto.zip is a database containing functions to allow you
to save the contents of an OLE Field to a disk based Bitmap file for the
entire table automatically.
NEW - Apr. 11/2000 This first version only supports Bitmap files.
Metafile support will be included in the next release. USe the
A2KExportOLEtoJpeg above instead of this older version!
SavePictureDataBitmap is a database containing functions to allow you to
save the contents of an Access Image control a disk based Bitmap file.
Specifically it creates a Bitmap file from the PictureData Property.
Updated - July 25/2000 This first version only supports Bitmap files.
Metafile support will be included in the next release. Now supports
saving of Form's Background picture to a disk based Bitmap file.
--
HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Heck" <heck@toodamnmuchspambutreallycomputer.org> wrote in message
news:usurb0td8rn7khoctdmjpc7c9ffjhfgdfu@4ax.com...[color=blue]
> You don't have think like ""bluetouchpaper" <sfhfdgh@sfgstf.com>" to[/color]
draw[color=blue]
> inspiration from a reality most only suspect, but it helps.[color=green]
> >My problem is when trying to embed or link a graphic into a table as[/color][/color]
a bmp.[color=blue][color=green]
> >I am developing an access database which has photos of clients.
> >
> >When I choose the object type, created from a file I get he following[/color][/color]
error[color=blue][color=green]
> >message.....
> >
> >"The connection with the OLE server says: the OLE server encountered[/color][/color]
and[color=blue][color=green]
> >error or Active X control was lost".
> >
> >I have search the internet for possible reasons and solutions. And[/color][/color]
have[color=blue][color=green]
> >tried everything that has been suggested. These include the[/color][/color]
suggestion[color=blue][color=green]
> >there is a possible confliction between Norton Antivirus and any[/color][/color]
firewall[color=blue][color=green]
> >that might be stopping script from running withing Access. I have[/color][/color]
removed[color=blue][color=green]
> >Norton 2003 antivirus and all other script stopping programs.
> >
> >So now I am at a total loss how to solve this error problem.
> >
> >What baffles me is that it also says the OLE has stopped?? and I[/color][/color]
cannot find[color=blue][color=green]
> >anywhere in Win2000 to restart the OLE.
> >
> >Many thanks to all who reply.[/color]
>
>
> I had what seems to be this very same problem. Turned out, the[/color]
program[color=blue]
> with which the pictures were originally viewed was no longer on the
> machine. Once it was returned, things were back to normal.
>
> What I still want to know is how to extract the picture info from the
> .mdb. I just wanted to get the raw binary image data, but I couldn't[/color]
do[color=blue]
> it. I didn't discover any simple way, such as Export, which would[/color]
produce[color=blue]
> either the photos or their data. Does anyone know how this data is[/color]
marked[color=blue]
> in the .mdb file? More generally, can someone point me to a[/color]
specification[color=blue]
> for the mdb file format?
>
> Thanks for your interest and reply.
>
> Harold Eckstein
>[/color]
