Adobe Acrobat Reader Problems

[atlbearcat]

All -

I have a form that has an OLE field in it for files (Excel, Word, PDF, etc.). The problem is that when the user opens a PDF file from the form, it opens fine. But, when they close the PDF file, Access generates an error...

The operation on the Acrobat Document object failed.

The OLE server may not be registered.

To register the OLE server, reinstall it.

I've checked the references in VBA, added all of the Acrobat related ones, tested it, and the same thing happens.

The users are running Acrobat 7 and above, the majority running 8.

Anyone figured this one out?

Thanks.

Jeff

[nico5038]

Hmm, this info from Microsoft looks to point in the direction of a reinstall of Office:
http://support.microsoft.com/kb/896865

Nic;o)

[atlbearcat]

Tried that....but still have the same issue. Tried the re-registering as stated in the kb article (even though it talks about data access pages). Still the same result.

The funny thing is....it only happens with Acrobat Reader 7 and above....

Someone out there has had to come up with a solution......

[nico5038]

Would it be an option to "drop" the embedded PDF document and switch to storing a hyperlink to the document in your table?
Thus a user can click the hyperlink and Windows will make sure that the proper installed PDF version is executed.

Nic;o)

[atlbearcat]

I would like to do that, but I'm dealing with a previously created database that has a rather large amount of items embedded. I can't easily convert them.

You would think that Adobe would play nice with MS....

[nico5038]

As you could have read, Adobe succeeded in getting the implemented PDF in the Office 2007 beta removed. You'll need to implement the reader in Office 2007 yourself...

OK, about your PDF version problem. As far as I know the OLE wrapper that's used to store documents will hold the information about the application the stored object will use to open. The only workaround when the different versions are conflicting, would be to store the PDF document outside Access before opening it.
Is that an option ?
Otherwise you would need to change the binary code in front of the document depending on the installed PDF version (that needs to be determined also...)

Nic;o)

[Bod]

I have the same problem, but I am using the linked option instead of embedding the PDF files.
It is fine on some PCs in our factory, but others have this self same problem. It only seems to happen of Acrobat Reader V7 & V8.
I have Acrobat Professional on my machine, and cannot simulate this problem as that opens and closes the linked files without any problems.
Any ideas from someone who has got round this problem would be appreciated.
Thanks
Phil

[thisisntwally]

I've been having the same problem since june (also inherited from those who came before me) and have yet to find a solution. With Access 03, and acrobat readers 7 and 8. Thought i might check in to see if anyone had a fix yet.