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
martmacAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

thenelsonCommented:
AFAIK, there is no work around for this when you store pdf files as ole objects.   If you check EE and other Access sites, you will see many posts from experts that say do not use ole fields.  Not only do you get prblems like this but your database will bloat tremendously.  I bet each ole/pdf file increases the size of the database by about 1 mb when the actual pdf file is only about 40-70 kb.  The best solution for this and other problems that will pop up is do not use ole fields for anything but very small graphics files like icons.  Instead save the pdf file outside of Access and create a text field to store the path/name of the file.  You would use:
Shell "Path/name to Accrobat" & " " & path/name of the file
to open in Accrobat.

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?
Yes, but only if you have stored the pdf outside of Access as above.   Create an unbound ole container control with Internet Explorer in it.  Address the imbedded IE to the pdf link.

Here is a utility that might get the ole files you already stored out of Access (I am not sure it will work with pdf files).
http://www.lebans.com/oletodisk.htm
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
martmacAuthor Commented:
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
0
thenelsonCommented:
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
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.