WD2000: Queries Not Available When Using Access Database

• Microsoft Word 2000

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:

1. In the Select Table dialog box, click Cancel.



2. 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.



3. In the Open Data Source dialog box, follow these steps:



1. In the Files of type box, select MS Access Databases (*.mdb, *.mde)



2. Select your Microsoft Access database file.



3. Click to select the Select Method check box.



4. Click Open.



4. 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.



5. In the Microsoft Access dialog box, click the Queries tab.

Additional query words: datasource msaccess

Keywords : kbdta kbmerge wd2000
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb