Error finding excel data source

[Rita]

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.

 

[Cindy M -WordMVP-]

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
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.

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