WD: Slow Performance Retrieving Access Data with Insert Database (181861)
The information in this article applies to:
- Microsoft Word for Windows 95, when used with:
- the operating system: Microsoft Windows NT
- Microsoft Word for Windows 95 7.0a, when used with:
- the operating system: Microsoft Windows NT
- Microsoft Word 97 for Windows, when used with:
- the operating system: Microsoft Windows NT
This article was previously published under Q181861 SYMPTOMS
When you use the Insert Database feature in Microsoft Word by retrieving
information via DDE from Microsoft Access on a Microsoft Windows NT version
4.0 operating system, it will retrieve the information from Microsoft
Access very slowly as compared to performing this same action in Microsoft
Windows 95 or Microsoft Windows NT 3.51.
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:
- Open the document in which you want to insert information from Microsoft
Access.
- On the View menu, point to Toolbars, and then click Database.
- On the Database toolbar, click Insert Database.
- In the Database dialog box, under Data Source, click Get Data.
- In the Open Data Source dialog box, click to select the Select Method
check box, select the Microsoft Access file, and then click Open.
- In the Confirm Data Source dialog box, click to select MS Access 97
Database via ODBC (*.mdb) and then click OK.
- If a Select Table dialog box appears, select a table, and then click OK.
Word 7.x
Follow these steps:
- On the Insert menu, click Database.
- In the Database dialog box, under Data Source, click Get Data.
- In the Open Data Source dialog box, click to select the Select Method
check box, select the Microsoft Access file, and then click Open.
- In the Confirm Data Source dialog box, click to select MS Access 7.0
Database via ODBC (*.mdb), and then click OK.
- If a Select Table dialog box appears, select a Table, and then click OK.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article.
Modification Type: | Minor | Last Reviewed: | 8/17/2005 |
---|
Keywords: | kbbug kbpending KB181861 |
---|
|