What's up with this??

[Gargamil]

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

 

[Peter Jamieson]

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.

 

[Gargamil]

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

 

[Peter Jamieson]

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

 

[lmercer]

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.