embedded pdf files won't open

B

Bear

I have used the same database thru several versions of Office and
Acrobat pro. Currently using office 2003 pro and acrobat 7.07.
Suddenly since the middle of February I can no longer count on opening
any files inserted after 2/16/06. The only message I get is The
operation on the Acrobat Document object failed. The OLE server may
not be registerd. To register the OLE server, reinstall it. At this
point I can close access, but can't reopen it. I have to reboot. I've
reinstall the ole server according to article 896865 to no avail.
Acrobat seems to continue to work, but when I close acrobat and shudown
for the day I get an error saying acrobat can't shut down. I have to
choose end now. About every 4 or 5 days the database works for a
while. I can't figure out what to try next. I think the problem lies
with acrobat, but I don't know how to solve it. I copied my database
to a different computer and installed acrobat 6 thinking that would
cure my problem and it wouldn't. Please help

Bear
 
G

Guest

Hi,
you should never embedd these files directly into access. It cannot handle
it and will either bloat or go corrupt.
Try scrap your ole field and add a text datatype field which only holds the
full text string path of the external pdf file.
You can then use the followhyperlink or shell method at runtim on the form
level to open up your documents e.g.:

Application.FollowHyperlink Me.YourControl

YourControl would be a control bound to the table field which holds the full
path.
HTH
Good luck
 
G

Guest

Thank you for taking time to answer my dumb question. I forgot that I had
posted in this newsgroup or maybe I'd have the problem fixed. It's been a
long time since I made the database. I'm wondering if I'd be better off to
make a new db and import the old info.

Gary
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top