How to retrive an ole embedded file
Hi,
I'm a student on a work term. I have to create a program that will control the publication created by many different scientist at where I work. The problem I have is that this was original done on a MS ACCESS database. The MS ACCESS database was copied exactly to a MSSQL server database. The problem with this is that the file/publications where stored in the ACCESS database as an ole object and this was copied exactly to a MSSQL database image(blob) type. The only problem is that when you store a file/ image in an access database it actually preforms ole embedding on the file, sort of wraps data around the file in order to be able to be open it up later. Now here is where I am all this was copied exactly to the MSSQL server bit for bit so I still have the embedding over the files and am not able to open them up. I am just wondering if there is a way to get rid of the embedding(extra bytes) or if I could use some kind of ACCESS or OLE object just to open the file up. I know most people will say don't use access to store images, but it wasn't me who did this. I just have to be able to open all these files back up now that they are on the SQL server. As far as I know you can never be sure how many bits the embedding has added on so I just can't read from a bit further. Please help me out.