SDK Resources & Microsoft Access

[Victor_Campbell@adobeforums.com]

We own Acrobat 9.0 Standard, and I have the SDK installed on my machine.

We develop and market a Microsoft Access application that comes with a PDF User Manual. Though the end user can browse that PDF themselves, we'd now like to add the functionality of integrating that PDF throughout the application at a touch of a button.

There are two ways of implementing this:
a. Open an Acrobat window within our Microsoft Access application.
b. Open an Acrobat Reader externally and send it to the relevant page.

The IAC documentation seems to indicate that both these options are doable. But I need help.

Questions:
1. Has this been done before, and if so, is there available an Access MDB with examples, including VBA code?
2. Is there an ActiveX, Plug-In, or Add-In available that would give me that functionality? Though I've worked with ActiveX objects in Access before, I'm not in a position to create one myself using VB.
3. I've successfully created code that opens an Acrobat window and sends it to a specific page. However, I've had some difficulties that indicate it's not nearly ready for distribution with our product.
a. Sometimes it opens the window, but it's frozen. It doesn't repaint, and is completely inaccessible. Today (with a brand-new Acrobat 9.0 installed) it opens repeatably just fine.
b. Though I've got the Acrobat.tlb on my machine, it's currently not checked as a Reference in the app, yet my commands still work.I'm puzzled.
c. Even though I Exit the Acrobat app object, and then kill the object, the Acrobat window now stays open. I have to close it manually. Why?, or, How do I kill it? (acro_app.Exit: Set acro_app = Nothing)
d. How do I test it on my machine using an Acrobat Reader? The VBA commands seem to rely on whatever is registered for PDF. For testing, is there a way to tell it which Reader I want it to use?

Help with any of these questions would be greatly appreciated. Thanks.

--Victor

[Leonard_Rosenthol@adobeforums.com]

First thing you need to do is download the Acrobat SDK and read the documentation and look at the samples. That would have answered most of your questions for you.

1 - There are no Access samples, but there are VB & C# samples.
2 - Yes, it's installed with Reader.
3 - Seems like problems with your code
3d - if you want Reader, then target Reader. If you want Acrobat, target Acrobat. If you want to test only one - VMWare, VirtualPC, etc. are great tools.