All Products  |   Support  |   Search  |   microsoft.com Guide  
 
  Home   |   Access   |   Excel   |   FrontPage   |   Outlook   |   PowerPoint   |   Word   |
July 15, 1996     Back to Microsoft Access Archives  

Using Microsoft Access as an OLE Automation Controller

As an OLE Automation controller, Microsoft® Access can manipulate any object in another application's type library. Examples of applications that expose their objects as OLE Automation servers include Microsoft Excel, Microsoft Word, and Microsoft Project, and some applications created with Microsoft Visual Basic® 4.0. Check your application's documentation to determine whether it can function as an OLE Automation server.

In Microsoft Access 2.0, you could use the CreateObject function or the GetObject function to point a variable to an instance of an application. In Microsoft Access for Windows® 95, you can also use the New keyword to create a new instance of some applications. Check your application's documentation to determine which syntax it supports.

In Microsoft Access, you can set a reference to an application's type library to improve performance when you control that application through OLE Automation. Microsoft Access also includes the Object Browser, a tool that enables you to view objects in another application's type library, as well as their methods and properties.

 

 
 
 

Tell us about this article
-Very worth reading
-Worth reading
-Not worth reading
-Too detailed
-Just right
-Not detailed enough
-Too technical
-Just right
-Not technical enough




 
 
 

Comments? Suggestions? Write us at MSDN@microsoft.com.

 
  © 2000 Microsoft Corporation. All rights reserved. Terms of Use.
Last Updated: January 4, 2000

 
  Best experienced with
Microsoft Internet Explorer
Click here to start.