• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 21. Using Access with Microsoft ... > In the Real World—Microsoft Query an...

In the Real World—Microsoft Query and OLE DB

Microsoft Query arrived in the era of Access 1.0, and has changed only in minor respects over the years. Microsoft Query's layout clearly derives from the Access query design window. Microsoft Query is one of the few remaining Office-related tools that relies on DDE—instead of COM-based Automation—for interprocess communication. Access's Mail Merge Wizard is the other tool in which use of DDE appears to be cast in concrete. Continuing to employ DDE when "COM Everywhere" is Microsoft's rallying cry is another good example of not fixing an unbroken technology. This chapter introduced you to Microsoft Query, creating a tenuous connection to the following discussion of the product's new OLE DB feature.

Excel 2000 depends on Query 2000 (Q2K, Msqry32.exe) to connect to databases, and previous versions of Microsoft Query relied on ODBC drivers for database connections. Q2K now offers support for OLE DB for OLAP, but only when you open Q2K from within Excel 2000 by choosing Data, PivotTable or PivotChart Report or Data, Get External Data, New Database Query. Figure 21.32 shows the OLAP Cubes page of the Q2K's Choose Data Sources dialog. (Refer to Figure 21.13 for the appearance of the dialog when you open Q2K from Word or in standalone mode.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint