I cant find an Access query which is a Word data source when I tr.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Louise - 23 Oct 2007 03:20 GMT

I am trying to locate an Access query I created but it is not appearing in
the word dialog box even though I know it exists. How can I get around this?

Reply to this Message

Peter Jamieson - 23 Oct 2007 08:25 GMT

Typically you need to change the way Word connects to Access - check Word
Tools|Options|General|Confirm conversions at open, then go through the
connection process again and select the DDE option when prompted. You will
probably then see all the queries in your database.

The background to this is that the default connection method for Word 2002
and later is OLE DB, which does not "see" certain types of query, such as
parameter queries. It does get other things right, e.g. deals with Unicode
data.

Peter Jamieson

>I am trying to locate an Access query I created but it is not appearing in
> the word dialog box even though I know it exists. How can I get around
> this?

Reply to this Message