Storing a PDF in an OLE Object Field in a Table?

[NorwalkPhil]

I am creating a PDF from and viewing an Access report with this code:
vRptFile = "c:\MyReport.PDF"
DoCmd.OpenReport "MyReport",acViewPreview
DoCmd.OutputTo acOutputReport,"",acFormatPDF, vRptFile,True

This works fine. Now I want to stored the same report in an OLE Object field in a table (so it can be uploaded into an Oracle BLOB field). I've tried several different methods to no avail. How do I do this? (I sincerely appreciate your attention)

 

[jrbarnett]

Look at the AppendChunk and GetChunk functions under ADO.

Not sure about Oracle, but certainly Access and SQL Server blobs will bloat the database quite considerably; you would do far better having a folder on disk for storing the files and storing a path/filename in a varchar (oracle) or text field in Access.

John