I have an application that uses SQL for the back-end. I want to create a custom report in MS Access. The problem is one of the fields is saved in SQL as a Binary Image. It is a notes field that is used for multiple purposes. It can save short text, or pictures. I only use it for short text. When I view the table through Access, it says "OLE Object". So I cannot query it or display the text on a report.
Is there any way to properly display/query this text??