Summary

The tight integration of Access with its siblings in the Office suite enables Office developers to take advantage of the great resources in Access. In addition, Access developers can tap the power of the other Office components.

This chapter presents a series of case-study examples with detailed instructions and sample code for making Access interoperate with Excel, Outlook, and Word. In the review of techniques for Access/Outlook interoperability, the chapter highlights a workaround to an Outlook security issue that prompts before granting programmatic access to Outlook items. While blocking selected viruses, this security technique also inhibits the operation of valid Automation procedures. By learning the samples in this chapter, you prepare yourself to create Access solutions that interoperate with any other package exposing its object model as a COM object and allowing programming via VBA.