Error finding excel data source

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rita - 01 Mar 2005 14:07 GMT

Since a recent upgrade to Office 2003 (as well as a concurrent change to my
excel data document), when I open my main merge document, I get the following
messages:
1. Opening this doc wil run the following SQL command: SELECT from "active
Sites$". Data from your DB will be place in the doc. Do you want to
continue? Yes No. This part is fine. But upon selecting YES, this error
message:
2. This operation cannot be completed because of dialog or database engine
failures. Please try again later. After clicking OK ...
3. I have to "Find data source" ... ...
I have to do this for each and every merge document since this particular
excel spreadsheet is the data source for all my merges.

Thanks for your help.

Reply to this Message

Cindy M -WordMVP- - 22 Mar 2005 22:00 GMT

Hi =?Utf-8?B?Uml0YQ==?=,

The database engine failure message is often an indication that you need to
download and install a newer version of MDAC (data access components). See this
KB article

http://support.microsoft.com/default.aspx?scid=kb;en-us;322215

> Since a recent upgrade to Office 2003 (as well as a concurrent change to my
> excel data document), when I open my main merge document, I get the following
[quoted text clipped - 8 lines]
> I have to do this for each and every merge document since this particular
> excel spreadsheet is the data source for all my merges.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)

Reply to this Message