Yet another DDE question!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sheila D - 21 Dec 2004 12:43 GMT

Hi

I am using Win XP, Word 2003 and Access XP/2002 and have the apparenty
common problem with linking to a parameter query in Access. I have tried the
Confirm Conversion at Open route which allows me to choose MS Access database
via DDE BUT I then get the message 'could not re-establish a DDE connection
to MS Access'

So my question is - is this an incompatibility problem, a Windows problem or
what. Not sure where the DDE converter comes from - Windows or Office but
can't find anything on Office 2003 CD to help.

I have a 2nd PC running Win XP and Office XP and got the same query to work
on that using DDE connection route and both machines are up to date with SP2
so don't think any difference in Windows set up. Any help would be much
appreciated.

Sheila

Reply to this Message

Peter Jamieson - 22 Dec 2004 02:23 GMT

I would look at the following article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;291445

DDE is an old component of Windows (to all intents and purposes). It isn't
really a format converter, but is a set of facilities for program-to-program
communication. In theory, DDE has been superseded by other technologies
(e.g., OLE Automation) but in practice it is still sometimes the only way to
do certain things. Unfortunately, it also seems rather flaky (on most of the
systems I've worked on it has been OK, but once it goes wrong it seems to go
/really wrong.

Peter Jamieson

> Hi
>
[quoted text clipped - 20 lines]
>
> Sheila

Reply to this Message

Sheila D - 22 Dec 2004 11:35 GMT

Hi Peter

Thanks for that but unfortunately did not help as I have no quotation marks
and database is shared. I guess this is something new in Word 2003 as I have
it working fine in 2002. Maybe if I upgrade to Access 2003 at some point it
will resolve!

> I would look at the following article:
>
[quoted text clipped - 34 lines]
> >
> > Sheila

Reply to this Message