what is long binary data in ms access

[zpimpernel]

I have a copy database containing 10,000+ image files but the table shows
'long binary data' in the field and the field type is set to OLE object - How
do I get the picture to display as an image?
Many Thanks
Mike

 

[Wayne-in-Manchester]

You CAN use MS Access for a D Base with 10,00+ photos BUT ???
Anyway
If you are looking to show the image it would 1st be a good idea NOT to
inbed the photos. Use the "either" choice from the properties (Data - OLE
type allowed) of the OLE object on the form. This way you can simply link to
the picture and so keep the size of the D Base down.

The best way to show the picture would be to save a thumbnail of the picture
as a WMF (metafile) and it is this that you store in the table. If you
really do need to show the full picture to clients are anyone else then link
the WMF (create a path hypelink to the full picture from the thumbnail).

Hope this helps.