Re: Queries missing from Access data source list
From: Peter Jamieson (pjj_at_KillmapSpjjnet.demon.co.uk)
Date: 09/04/04
- Next message: Thomas Dawe: "Property Linking"
- Previous message: Peter Jamieson: "Re: Insert comma into address block"
- In reply to: george atkins: "Queries missing from Access data source list"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 4 Sep 2004 09:13:12 +0100
Word does not "see" certain types of query when it connects to the database
using OLEDB, which is the default connection method in Word 2002 and later.
In particular, it does not "see" UNION queries, parameter queries, queries
containing a coiuple of "rogue" financial functions, and (AFAICR) queries
containing user-defined functions. If the missing queries are those sorts of
query, that is probably the explanation. If you chnage the connection method
to DDE (check Word Tools|Options|General|"Confirm conversions at open", go
through the connection process again, and select DDE when offered, you
should see all the tables and queries. You will certainly need to use DDE to
use parameter queries, but some of the others may be accessible if you try
connecting via ODBC.
-- Peter Jamieson "george atkins" <anonymous@discussions.microsoft.com> wrote in message news:030201c48f6a$ae2b38b0$7d02280a@phx.gbl... > When creating a Word mail merge (in Office 2003) to an > Access database, I do not see the entire list of queries. > In fact, after listing about seven tables and "views", the > list stops. The database has about 50 queries in it. > > I started with an Access 2000 database, then converted it > to a 2002-2003 format. Same results. > > Has anybody seen this behavior? > > TIA!
- Next message: Thomas Dawe: "Property Linking"
- Previous message: Peter Jamieson: "Re: Insert comma into address block"
- In reply to: george atkins: "Queries missing from Access data source list"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
