Insert PDF doc in a table

[filo65]

Hi,

in my googling I came accross to the articlel 198466 that should allow me to insert PDFs in a table.
I followed the instructions, but I got an error message

  ....
  Do While Len(MyFile) <> 0
      [OLEName] = MyFile
      [OLEfFile].Class = "Adobe.Acrobat7.0" ' or "Adobe Acrobat 7.0 Document"
      [OLEfFile].OLETypeAllowed = acOLEEmbedded
      [OLEfFile].SourceDoc = MyFolder & "\" & MyFile
      [OLEfFile].Action = acOLECreateEmbed        '<----------- Error '2777'
   ....

two questions:
1) is there somewhere a list of OLE-Classes and which is the appropriate for PDFs?
2) the example is based on a form linked to a table; I would like to skip the form; is it possible?

Thanks in advance

filippo

 

[tokoloshi]

Hi Filo65

Did you get a response/answer to this puzzle?

I have the identical problem.

T

 

[Rabbie]

It is usually better not to store the the .pdf document in a table but instead store the .pdf file separately and store its address in the table. This reduces the risk of the DB becoming bloated.

This technique is similar to that reccomended in this forum for store images so do a search of the forum for storing .jpg files etc. i know there have been posts on this recently.

 

[tokoloshi]

Thanks Rabbie,

Due to the business rules behind the app I am forced to store the document in the database.

I have also rephrased the question along with the code I am using and posted it as a new thread.

Could you visit:
http://www.access-programmers.co.uk/forums/showthread.php?p=787028 and comment in that post please?

 

[DCrake]

Refer to this post for the solution

Do not post duplicate questions, instead revist the original thread and edit the post.

David