I'm trying to store word documents in a sybase table, by loading them from an Access frontend.
I understand that they need to be stored as data type image.
My intention was to pass the document from its converted state where it is stored in a Access frontend table in an field of datatype OLE, to the backend as type image using a stored procedure, but then read that you can't use the datatype 'image' in an SP. If this is the case then how does one go about it? or conversely if it is easier to pass the document to the sybase backend and convert it there.
The nearest thing I have found on the Sybase Support page is tellimg me to look at a script called 'instpix2' which is good example of how one goes about inserting images but I can't find it so am still stumped.....