Paste Link Unavailable Copying Access Table from the Clipboard

ID: Q106647

The information in this article applies to:

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

Last Reviewed: February 6, 1998