HISCorsair
Programmer
I'm trying to do what seems like it should be a simple task, but is turning into a nightmare. I have a program with an Access 2000 database, which needs to store an image into an OLE Object field, and then retrieve that image for a Crystal Reports report to display.
I'm using an unbound form with the Data Environment as its connection to the database, loading values through code, but I've even tried binding a picture box direct to the Data Environment command. No matter what I do, I keep getting "Long Binary Data" in the OLE Object Field, and Crystal can't read the image.
Does anyone have code that successfully stores an image in an Access 2000 OLE Object field and retrieves it in Crystal, or in a Microsoft Data Report? I've been told there's a known problem with Access wanting to add its own headers onto OLE Object fields, and that this may be the source of my trouble, but no solution was given.
This is the last major hurdle between me and finishing this project, which is already past due. Surely it isn't this hard? Any help is appreciated.
J. Broadus
corsair@hiscommunications.com
I'm using an unbound form with the Data Environment as its connection to the database, loading values through code, but I've even tried binding a picture box direct to the Data Environment command. No matter what I do, I keep getting "Long Binary Data" in the OLE Object Field, and Crystal can't read the image.
Does anyone have code that successfully stores an image in an Access 2000 OLE Object field and retrieves it in Crystal, or in a Microsoft Data Report? I've been told there's a known problem with Access wanting to add its own headers onto OLE Object fields, and that this may be the source of my trouble, but no solution was given.
This is the last major hurdle between me and finishing this project, which is already past due. Surely it isn't this hard? Any help is appreciated.
J. Broadus
corsair@hiscommunications.com
