WD: Slow Performance Retrieving Access Data with Insert Database

WORKAROUND

To retrieve data from Microsoft Access into Microsoft Word by using the Insert Database button on the Database toolbar without a performance deprivation, use the Open Database Connectivity (ODBC) method of retrieval rather than the Dynamic Data Exchange (DDE) method of retrieval. To do this, follow the steps appropriate for your version of Word.

Word 97

Follow these steps:

1. Open the document in which you want to insert information from Microsoft Access.
2. On the View menu, point to Toolbars, and then click Database.
3. On the Database toolbar, click Insert Database.
4. In the Database dialog box, under Data Source, click Get Data.
5. In the Open Data Source dialog box, click to select the Select Method check box, select the Microsoft Access file, and then click Open.
6. In the Confirm Data Source dialog box, click to select MS Access 97 Database via ODBC (*.mdb) and then click OK.
7. If a Select Table dialog box appears, select a table, and then click OK.

Word 7.x

Follow these steps:

1. On the Insert menu, click Database.
2. In the Database dialog box, under Data Source, click Get Data.
3. In the Open Data Source dialog box, click to select the Select Method check box, select the Microsoft Access file, and then click Open.
4. In the Confirm Data Source dialog box, click to select MS Access 7.0 Database via ODBC (*.mdb), and then click OK.
5. If a Select Table dialog box appears, select a Table, and then click OK.