I would guess that it is trying - and failing - to close the data
source. (See my other message about DDE being on its last legs). That
could be because either Word or Access is not seeing the DDE
communicaiton that it is expecting, or because you are not seeing and
responding to a dialog box because it's hiding behind another window, or
because DDE has "hung".
It might or might not help to open Access and your database before you
open the Word document.
Peter Jamieson
http://tips.pjmsn.me.uk
Daniel J. Parietti wrote:
THank you Graham. OK. I was able to merge the data into the Word document
and to have the data to appear in the Word document. But now it's taking
forever. and ever and ever... to save the document after I make any cahnges
to. What's going on ?
"Graham Mayor" wrote:
Office Button Word Options Advanced General Check 'Confirm file
format conversion on open'.
--
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
Daniel J. Parietti wrote:
To PEter or ANyone Else Who Might Able to Assist:
I am using Office 2007 and am having the same problem as that
related by the user 'faresatpta'. I followed the directions you
provided in your reply but was not able to find (in the Advanced
settings) any option where I can specify the DDE option for Word
documents to communicate with my Access '07 databases.
Any other thoughts. I've been knocking my head on this problem for
a few days and am getting behind in my work. Otherwise, I will have
to reinstall Office '97.
Dan (Let's Go Sail Lightnings!)
"Peter Jamieson" wrote:
Which version of Word/Access?
Typically to see all the queries, including parameter queries,
queries that use user-defined Access VBA functions, and so on, you
have to connect to Access using DDE . he default method since Word
2002 has been OLE DB. To change to DDE, in Word 2002/2003 check Word
Tools-Options-General-Confirm conversions at open, go through the
connection process again, and select the DDE option when you see it.
If you're on Word 2007, the option is in Office Button-Word
options-Advanced (near the bottom) and you may also have to click
the "Show all" button in the Confirm Source dialog box.
Other query types can cause problems too, e.g. if they contain
wildcards - but maybe you could let us know if that is the case.
--
Peter Jamieson
http://tips.pjmsn.me.uk
"faresatpta" wrote in message
...
When I try to do a mail merge using a query in one of my Access
databases, not all queries are showing up on the list when I select
the database. This
used to work and showed all the queries in that database, but
stopped working.