Link to home
Start Free TrialLog in
Avatar of martmac
martmacFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Specifying what to open a PDF with from an OLE field.

Here's an interesting one that is driving me insane.

Access2003 with Windows XP.

I have a direct scan and save function that enables the user to press a button which scans a document, converts it to PDF and saves the result in an ole field. When the user opens the PDF from the ole field the document opens fine in Acrobat Reader, but when the user closes down the file, the following message appears.

"The operation on the Acrobat document failed.
The OLE server may not be registered.
To register the OLE server, reinstall it."

It has no effect on the document or the application and the user is able to reopen the document at will without a problem. But each time the document is closed, the error above appears.

There are two real questions here.

1. Has anyone experienced this problem or know why it is happening?
2. Rather than open the ole field in Acrobat reader, is there any way I can get the ole field activation to use Internet Explorer to view the PDF instead?

Many thanks
ASKER CERTIFIED SOLUTION
Avatar of thenelson
thenelson

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of martmac

ASKER

Many thanks, I rather thought this was the answer. I am accutely aware of the ole issue, but have faced real problems in relation to sharing documents due to significant networking restrictions that led to the ole choice. I have needed to get to grips with this for some time and I think now is the time to do it.

The app will make it much easier to get the files out, so it's time to take a stiff drink and deal with the reality of a long overdue decision.

Thank you for your help.

Martin
Avatar of thenelson
thenelson

If the networking sharing restrictions make it dificult to access the external files, then you can store the data within Access as raw BLOBs.  Not a trivial task (don't understand why M$ has never provided built in BLOB support like their competitors do).  Here are some references:

http://www26.brinkster.com/alzowze/blobs/blobs.asp
http://www.granite.ab.ca/access/imagehandling.htm
http://support.microsoft.com/?kbid=103257
http://www.jamiessoftware.tk/articles/handlingimages.html

Glad to help.
Happy Computing!

Nelson