If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Queries missing from Access data source list
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! |
#2
|
|||
|
|||
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" wrote in message ... 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! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Images in a database | Franz | General Discussion | 10 | October 7th, 2004 09:35 AM |
Struggling with MS Query... | Alex | General Discussion | 5 | July 6th, 2004 11:46 AM |
Excel Data List - why does it delete the data below the list? | ryanlillywhite | General Discussion | 1 | June 14th, 2004 06:56 PM |
Linking Excel data through Access to use a Form as an Interface | Laura | Links and Linking | 0 | March 23rd, 2004 03:59 PM |