How to save an OLE Object to Long Binary
We currently have a SQL database that has embedded OLE objects that were stored using the Access VBA AppendChunk() method. What I would like to do is store these objects as just plain long binary data so I can open it through ASP.
I was thinking of doing this by writing a macro to open each OLE object, store it to a temporary file and then save it back as long binary in another table.
Can anyone give me any tips to do this? Very new to Access and VBA, any help would be greatly appreciated. Thanks.