Re: DDE connection w/ Access & Word 2007

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

The Word
doc the message is referencing is clearly a temporary file, as it is most
definitely not the actual file name, and changes each time I try opening it.


Yes, this is how Word, or Vista, seems to work now - it seems to regard accessing network files as being similar to downloading via Internet Explorer. I've always rather hoped that we are not in fact dealing with at least three different views of how to check security (Windows networking's view, Word's "Trusted locations view", and IE's view, but it's not beyond the bounds of possibility.

If I try a .doc that was only ever edited in Word XP, I get a different
message, and this is what led me to try converting everything to the Office
2007 versions in the first place.

Here, it is OK, but there is a difference. If I set up a new document on Win XP/Office XP using DDE, Access XP opens the .mdb and makes the connection fine.

However, when I go back to my Vista/Word 2007 environment and open the Word file, I can see Access 2007 searching for the file dao360.dll. It takes quite a long time to complete. Then it opens the file and presents the query prompt. It's difficult to tell whether it actually finds dao360.dll or not, but it is on my system (in C:\Program Files (x86)\Common Files\microsoft shared\DAO ). So it is also possible that in some cases Access is "timing out" looking for that file. In that case, with a DDE connection, I would normally expect Word to show its "connection is taking longer than expected - do you want to wait" prompt, but perhaps some other factor is coming into play here.

I don't know what to suggest at this point. The only thing I can think of is to try to move towards a solution based on OLE DB rather than DDE, and at this point I do not know how feasible that is. It would at the very least involve some VBA coding, some prompts issued by Word, and knowledge of exactly what parameters were expected by the Access Query.

--
Peter Jamieson
http://tips.pjmsn.me.uk

"mariacle" <mariacle@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:0CC79A00-525D-4F24-940B-C07EBD4CD474@xxxxxxxxxxxxxxxx
If I try a .doc that was only ever edited in Word XP, I get a different
message, and this is what led me to try converting everything to the Office
2007 versions in the first place. The error message I get with the XP files
is: "D78907BC.doc is a mail merge main document. Word cannot find its data
source \\hfadc01\shareddocs\...\omega.mdb."

From what I can see of the path to the database, it is correct. The Word
doc the message is referencing is clearly a temporary file, as it is most
definitely not the actual file name, and changes each time I try opening it.

From this point, the only option that works is to remove all merge info and
start over, but then if I save it and re-open it, I get the DDE connection
error that started this whole thread.

.

Relevant Pages

  • Re: DDE connection w/ Access & Word 2007
    ... "Peter Jamieson" wrote: ... Access XP opens the .mdb and makes the connection ... In that case, with a DDE connection, I would ... expected - do you want to wait" prompt, but perhaps some other factor is ...
    (microsoft.public.word.mailmerge.fields)
  • Open Word From Excel, Different Actions
    ... I created a mail merge word document, data comes from Excel. ... Opening this document will run the following SQL Command..... ... However, if i run the following code from Excel, the document opens, ... but doesn't prompt me and it contains unrefreshed data. ...
    (microsoft.public.excel.programming)
  • Outlook 2000 / attachments opening system32 folder
    ... On a few machines, I'm having trouble with opening an ... a prompt *didn't used to* to open or save, ... it opens the system32 folder. ...
    (microsoft.public.outlook)
  • Re: update file by DDE
    ... use setlinkondata to create a dde connection - that is done with a cell ... formula and there is no reason to have setlinkondata unless you need a macro ... My problem is in the first routine (sub verification ()), ... Every file the Sub verificationopens, ...
    (microsoft.public.excel.programming)
  • Re: MailMerge WORD2003 - EXCEL2003
    ... You click "YES" and only open the word document. ... And the Excel not. ... Word only opens the Excel application with the merge source if ... you're using a DDE connection. ...
    (microsoft.public.word.mailmerge.fields)