I created a table that has a ole object field labeled PDF to store Adobe documents.
I have a form that has that ole object on it. I have the settings set for embedded object so the document would be stored in the MDB and not somewhere else in a folder where it could accedintally be deleted. When I click on the ole object frame to add it, I don't have any problems getting the pdf document. It is when I open the document in a Adobe 7.0 reader.
When I double click on the ole object frame the auto activate does its thing and openes the document in the acrobat reader, but when I close the acrobat reader I get an ole server error.
'The operation on the Acrobat Document object failed.
' The OLE server may not be registerd.'
' To register the OLE server, reinstall it.'
'| OK |
I then tried the same thing with a computer that has adobe pro, which allows writing adobe documents, and I don't have the problem.
I even tried leaving the adobe reader open prior to double clicking, auto activate, the pdf ole object and still get the error when I close that particular document.
Is there a way to control acrobat so I don't get this error in an adobe reader vise an adobe writer.
I have adobe as a reference, but I don't unstand the codes that control it.
I just want to beable to click on a button that does two things.
1) if ole object is null, get object from file.
2) if ole object is not null, then open pdf in read only mode, once adobe is closed return focus back to ms access.