If you use Adobe Reader X it is possible you can't open OLE PDF documents in the standard.
The reason is the 'save box mode' in adobe reader X.
Many people think the protected Mode of adobe reader x is only to stop the write access.
But this feature blocks the open access for OLE documentes too.
OLE by design means that you open a document for instant access for reading and writing.
You take only a reader for your access, but a OLE document every time needs and order write access,
if you chage the document or not.
So it's not only if you want to write to PDF documents, but also, if you want to open OLE PDF documents it's doesn't work too.
You can solve this problem one or two ways:
1. deactivate the 'save box mode' :
- open adobe readerX
- go to menu EDIT-Preferences
- change to categorie GENERAL
- deactivate the point "Enable Protected Mode at Startup"
- click yes if the question comes if you sure to change the prereferences
- save the changes with OK
- restart the adobe acrobat reader now or later and the changes wil be take affect
Now you can open older OLE PDF documentes and create new OLE PDF documentes e.g in your database
2. Do not use OLE documents,
Use packaged documents in the registry for PDF (for future documentes).
For older documents it's not possible to go this way, but you can save a OLD PDF document, after you change the registry entries from OLE to package document and after this you create a new package document (e.g. in your database on the same place)
How to change from OLE to packaged documents is not part of this Article, but you can find the answer specific for your own windows system.
A query can call a function, and a function can call Excel, even though we are in Access. This is Part 2, and steps you through the VBA that "wraps" Excel functionality so we can use its worksheet functions in Access.
The declaration statement de…