What's up with this??

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gargamil - 18 Apr 2004 09:35 GMT

I am trying to construct a mail merge using Office XP. It all worked fine
in 2000 but now when I open the Word document and try to find the data
source it cannot find it. I open the database and scroll through the list
of possible sources and it is nowhere to be seen. Why why why is XP so
painful??

Where's my query??

g

Reply to this Message

Peter Jamieson - 18 Apr 2004 16:06 GMT

XP has changed the way it connects by default to Access (and other) data
sources. In 2000 it used to use DDE, which started Access and could
generally see all the queries. In XP it uses OLEDB and seevral types of
query are excluded (in some cases it is possible to see why that might
be,but in other cases it isn't at all obvious). Try checking Word
Tools|Options|General|"Confirm conversion at open", going through the
connection process again, and selecting the DDE option (or the ODBC option)
when prompted.

Signature

Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/

> I am trying to construct a mail merge using Office XP. It all worked fine
> in 2000 but now when I open the Word document and try to find the data
[quoted text clipped - 5 lines]
>
> g

Reply to this Message

Gargamil - 18 Apr 2004 22:25 GMT

Peter,

The problem is not tat is doesn't see the queries more that it doesn't
see one particular query. And it's only a select query. I have specified
the DDE option since this will live on a path everyone will have access to.

g

> XP has changed the way it connects by default to Access (and other) data
> sources. In 2000 it used to use DDE, which started Access and could
[quoted text clipped - 14 lines]
> >
> > g

Reply to this Message

Peter Jamieson - 19 Apr 2004 08:12 GMT

Can you see anything unusual about this particular query? FOr example,
Word+OLEDB will not list several types of SELECT query, e.g.
a. parameter queries
b. UNION queries
c. queries that reference user-defined functions (written in Access VBA)
d. queries containing certain VBA functions

Signature

Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/

> Peter,
>
[quoted text clipped - 25 lines]
> > >
> > > g

Reply to this Message

lmercer@pavilionhg.co.uk - 28 Apr 2004 10:14 GMT

I have noticed that XP does not show up linked tables in
Access DB as mailmerge sources. I create two DBs, a data
one containing the tables and a system one with the forms
and VB, with links to the data one for tables. Word 2000
would allow me to use the system one as the datasource,
whereas 2002 does not show the tables unless I point to
the data db.
I hope this helps.
Les.

>-----Original Message-----
>XP has changed the way it connects by default to Access (and other) data
[quoted text clipped - 17 lines]
>
>.

Reply to this Message