Microsoft KB Archive/211193

= WD2000: Queries Not Available When Using Access Database =

Article ID: 211193

Article Last Modified on 12/6/2000

-

APPLIES TO


 * Microsoft Word 2000 Standard Edition

-



This article was previously published under Q211193





SYMPTOMS
When you use a Microsoft Access database file as a data source in Microsoft Word, Access queries may not be available. Instead, the Select Table dialog box is available for you to select which Microsoft Access table you want to use.



CAUSE
Microsoft Word 2000 may be using the ODBC (Open Database Connectivity) driver to open your Microsoft Access database file. When Word uses this driver, Microsoft Access queries are unavailable by default.



RESOLUTION
Use the following steps to access your Microsoft Access database queries:  In the Select Table dialog box, click Cancel. Do one of the following:  If you are using a Microsoft Access database as a data source in a Word mail merge, in the Mail Merge Helper (on the Tools menu, click Mail Merge), click Get Data, and then click Open Data Source.

-or- If you are inserting a database in a Word document, in the Database dialog box (on the Database toolbar, click Insert Database), click Get Data.

NOTE: To see the Database toolbar, on the View menu, point to Toolbars, and then click Database.  In the Open Data Source dialog box, follow these steps: <ol style="list-style-type: lower-alpha;"> In the Files of type box, select MS Access Databases (*.mdb, *.mde)</li> Select your Microsoft Access database file.</li> Click to select the Select Method check box.</li> Click Open.</li></ol> </li> In the Confirm Data Source dialog box, select MS Access Databases via DDE (*.mdb, *.mde), and then click OK.

NOTE: If MS Access Databases via DDE (*.mdb, *.mde) is not available, you will need to remove and then reinstall Microsoft Access 2000.</li> In the Microsoft Access dialog box, click the Queries tab.</li></ol>

Your Microsoft Access queries should now be available.

Additional query words: datasource msaccess

Keywords: kbmerge kbprb KB211193

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.