Microsoft Access OLE question

Factual Questions
1

I didn’t have much luck searching the SD archive or the web for a solution to this problem.

I am building a Microsoft Access database and I want to be able to link to and open (and close!) pdf files using Adobe reader. The particular cells in the table are formatted for OLE objects and I can insert pdf files easily enough. The problem is when I try to close the pdf or Adobe Reader I get the following pop-up window:

“The operation on the Acrobat Document object failed.”
“The OLE server may not be registered.”
“To register the OLE server, install it.”

What’s weird is that the first time I close a newly linked document it closes fine. The second time I open the file I get the above message when I close it. It’s like the file is closed incorrectly initially.

When I go to System Information > Software Environment > OLE Registration, Adobe Acrobat Document is listed “c:\program files\adobe\reader 8.0\reader\acrord32.exe”.

My pdf files are on a server and not my hard drive, but I don’t know if that matters.

If I go to the ActiveX controls in the Tools menu, Adobe PDF Reader is listed as available. If I highlight it and click register, I’m prompted for a place to put it and it wants a file name. I’d tried sticking in the default Adobe folder, but after I type a name in the file field and click OK nothing seems to happen—the window is still there.

What gives?

I’m using Access 2003, Office Professional Edition 2003 and running Windows XP Professional.

Any help would be appreciated.

2

I don’t have much help to give, other than to say that you’re not nuts–I was able to recreate this error exactly as described. My original thought was that the Acrobat Reader process wasn’t properly closing the first time, and that was causing some sort of clash when reopening the file. I’ve seen AR do that sort of thing before–but it doesn’t seem to be what’s going on here.

3

This question has apparently been asked and answered on experts-exchange.com. (Which, by the way, was a much more enjoyable website to go to before they added the hyphen.) Unfortunately, you need a paid membership to view the alleged solution … For a solution to be there, the original questioner had to have pronounced it satisfactory, so there’s some sort of useful info behind the invoice. Maybe someone here is a member & is willing to check?