Microsoft KB Archive/110653

From BetaArchive Wiki

WD6x: Queries Tab Not Available When Using Access via ODBC

Q110653



The information in this article applies to:


  • Microsoft Word for Windows, versions 6.0, 6.0a, 6.0c





SYMPTOMS

When you use a Microsoft Access database file by means of ODBC as a mail merge data source or as a DATABASE field, the Queries tab (as pictured on page 678 in the Word 6.0 User's Guide) is not available.



CAUSE

Microsoft Access must be running to generate the results of a query. ODBC drivers do not activate the source application; they access the data file created by the application.



WORKAROUND

To use an Access query as a data source, open the file using dynamic data exchange (DDE) rather than ODBC.

If DDE is not available:


  1. If Microsoft Access is not installed on the computer, install it. If Access is installed, then remove Access through its setup program and then re-install Access.
  2. Make sure the Confirm Conversions option is selected in the Open Data Source dialog box. Also, verify that the following line is in the [Extensions] section of your WIN.INI file

          MDB=<path>\msaccess.exe  ^.MDB 

    where <path> is the location of the Access program directory. For example:

          MDB=C:\ACCESS\msaccess.exe  ^.MDB 

Additional query words: datafile datasource

Keywords : kbinterop kbusage winword kbmerge word6
Issue type :
Technology : kbWordSearch kbWordWSearch


Last Reviewed: November 4, 2000
© 2001 Microsoft Corporation. All rights reserved. Terms of Use.