Paste Link Unavailable Copying Access Table from the Clipboard

 Last reviewed: February 5, 1998
Article ID: Q106647
The information in this article applies to:
  • Microsoft Word for Windows, version 6.0

SYMPTOMS

The Paste Link option is not available when you choose Paste Special from the Edit menu after you copy a Microsoft Access database table to the Clipboard.

STATUS

The Paste Link option is available when using Word version 6.0a. A Paste Link will still not update correctly. This is due to a problem in Access. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

WORKAROUND

To create a link to a Microsoft Access table in your Word document, use the Database command on the Insert menu. In the Insert Data dialog box, be sure to check the Insert Data As A Field check box. This will allow you to update your data by pressing F9.

Note: If the linked field from Access is re-formatted in Word, the formatting will be lost when F9 is pressed to update this field.

MORE INFORMATION

Another way to create a link to a Microsoft Access table is to manually insert a DDE field into your document. For example: 

   {DDE MSAccess "database.mdb;Table tablename" All \* mergeformat \t}
To create this field manually, press CTRL+F9 to create the field brackets, type in the above field code, and press F9 to update the field and establish the link. The database must be open to successfully create and update the link.

For more information on linking from a Microsoft Access database to a Word for Windows document, query on the following words in the Microsoft Knowledgebase: 

   msaccess and ddeauto

KBCategory: kbusage
KBSubcategory: kbformat
Additional query words: 6.0 b_waccess winword word6
Keywords : kbformat
Version : 6.0
Platform : WINDOWS

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 5, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.