Updating ole object msaccess
The extent to which a program implements OLE is up to the program's developers.
Thus, some of your programs may be able to function as an OLE server, but not a client; some may not support OLE at all. This means you can take information from other OLE servers, such as Excel, and insert it in your Access tables.
With OLE, there are three particular terms whose meaning you need to know: As you examined the OLE terms, you may have gotten the idea that there are programs that provide information (servers) and those that receive it (clients).
So how do you find out what objects are available to you? When you install a program under Windows, the program lets Windows know whether it can support OLE and to what extent.
In Chapter 15, "Importing and Exporting Information," you learned how Access can be a "good neighbor" by sharing data with other programs.
In this chapter, you will learn how Access can work with other programs in a different way--by letting you link or embed information within a table.
For example, if you link an Excel chart into your table and later modify the spreadsheet data (from within Excel) on which the chart is based, the linked chart within your Access table automatically changes to reflect the modifications.
If you had linked the chart to seven different tables, each table will automatically show the change.