Hi Guys,

I would like to know if some of you can help me on how to embed an OLE object into an OLE Field in Microsoft Access 2003 Database?

So far I have a form with the OLE container, I can load the image using this code:

Dim strFile As String

strFile = "C:\test\document.pdf"

OLE1.CreateEmbed strFile

So, now I want to embed this document into the field, I used this insert and it works:

Set gRS1 = gCon.Resultset("Insert into pdfDocs (docs) values('" & OLE1.SourceDoc & "')")
Set gRS1 = Nothing

The thing is that the OLE object gets saved as a Long Binary Data and I would like to be as a Adobe Acrobat Document so that the user can click on the field and it will open in Acrobat reader.

Any ideas?

:D

=======================
Strange and crazy, but everything is possible

__________________
=======================
Strange and crazy, but everything is possible