ACC97: Word DDE Connection Error Using Table or Query w/ Quotes
ID: Q168314
|
The information in this article applies to:
-
Microsoft Access 97
-
Microsoft Word 97 for Windows
SYMPTOMS
Moderate: Requires basic macro, coding, and interoperability skills.
When you try to establish a DDE connection from a Word document to a
Microsoft Access table or query by using the Insert Database command in
Word, you may receive the following error message:
Word could not re-establish a DDE connection to
Microsoft Access to complete the current task.
CAUSE
The table or query in Microsoft Access that you are trying to link has
quotation marks in its name.
RESOLUTION
Before you try to create a DDE link, you should rename any table or query
that you want to use in the DDE connection with Word so that it doesn't
have quotation marks.
MORE INFORMATION
Steps to Reproduce Behavior
- In Microsoft Access 97, open a database and create a table that contains
some data.
- Close and save the table as "Table"1 (make sure you include the
quotation marks).
- Open Microsoft Word and create a new document.
- On the View menu, point to Toolbars, and then click Database.
- On the Database toolbar, click the Insert Database button. In the
Database dialog box, click Get Data.
- In the Open Data Source dialog box, in the Files Of Type box, click MS
Access Databases (*.mdb).
- In the File Name box, type the name of the Microsoft Access database
that contains the table that you want to open, and then click Open.
- In the Microsoft Access dialog box, click the Tables tab, and then
click the "Table"1 table. Click OK. Note that you receive the error
message mentioned in the "Symptoms" section.
REFERENCES
For more information about exporting Microsoft Access data to Word, search
the Help Index for "Word (Microsoft), exporting Access data to Word," or
ask the Microsoft Access 97 Office Assistant.
Keywords : kbinterop
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbprb