How Do I Find the Data Source?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TC - 15 Apr 2004 23:24 GMT

I have a mail merge document which uses, as its data source, a query in an
Access database. I would like to know the name of that query. Unfortunately,
the database is not where Word expects it to be. When I try to open the
merge document, therefore, Word informs me that the data source cannot be
found, then removes all information about the data source.

How can I either 1) open the file without losing the path to the data
source; or 2) read the data source without opening the file?

I am using Office 2000, by the way.

-TC

Reply to this Message

Peter Jamieson - 16 Apr 2004 07:54 GMT

Try checking Word Tools|Options|General|"Confirm conversions at open". Then,
if you happened to save the file in HTML or RTF format, open it as a plain
text file and the relevant info should be readable. Otherwise, use the
"Recover text from any file" option to view the .doc. I do not know if that
will actually show you the file name but I suspect it will be your best bet

Signature

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

> I have a mail merge document which uses, as its data source, a query in an
> Access database. I would like to know the name of that query. Unfortunately,
[quoted text clipped - 8 lines]
>
> -TC

Reply to this Message

TC - 17 Apr 2004 01:30 GMT

Peter,

Thank you for the reply. In fact, I found a workaround (and therefore did
not need to try your suggestions), but I am grateful for the advice.

-TC

> Try checking Word Tools|Options|General|"Confirm conversions at open". Then,
> if you happened to save the file in HTML or RTF format, open it as a plain
[quoted text clipped - 15 lines]
> >
> > -TC

Reply to this Message

Rate this thread: