How can I view binary data in access

[D Lou]

Hi,
I used access to link into our sqlserver and view the data in the tables. I
can't view the content fields that are in binary (used to store long
descruption), it only show OLE object. Is there anything that I can do to
view this data?

Thanks

 

[Sylvain Lafontaine]

You must use a OLE Bound Control (don't remember the exact name) on an
Access form (from a MDB or ADP file) to display OLE objects.

 

[J. Clay]

If it is not an OLE object, you can use the ADO Stream function to stream
the data out to a file and then link to the file.

Jim