Find Data Source Error Word and Excel 2003

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Scott Miller - 03 Mar 2004 16:38 GMT

Spent the weekend upgrading the office to Server 2003 and
Office 2003. everything went well.. Well mostly.

Problem I am having is this.

We have approx 10 files that mail merge excel documents
into a word document.

The files import without an issue on the admin account
and two of the files work great on everyones accounts.

The other mail merge document files do not work on
anyones accounts except administator accounts.

I get a file data source prompt and then when I open the
file it will not import the information.

I have set permissions on the documents and the folder
for everyone to have full control.
Still does not work.

Any help would be appreciated.

Reply to this Message

Peter Jamieson - 04 Mar 2004 09:51 GMT

I would start by guessing that the merge main documents may be using
different methods to connect to the data source (with Excel there is a
choice of DDE, the Converter, ODBC and OLEDB) and that there could be a
security problem to do with either
a. one of the .dll or other files used by one of the connection methods or
b. any temp files used by the method that doesn't work.

Seems a bit unlikely though. FWIW these sort of problems seem to affect
people using Terminal Server more than anyone else.

I'm not aware of any of the methods producing temp files - although they
might - so I'd probably start by looking at (a).

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

> Spent the weekend upgrading the office to Server 2003 and
> Office 2003. everything went well.. Well mostly.
[quoted text clipped - 18 lines]
>
> Any help would be appreciated.

Reply to this Message

Scott Miller - 05 Mar 2004 15:11 GMT

You are correct in that we are using Terminal Server.

I ended up finding a workaround.
It seems that the files have to be on the local drive of
the system that you are running Office from.

I tried everything else in these forums and on the
Microsoft websites. I even spent 3 hours on the phone
with Microsoft reps.

The only thing that worked was the most simple fix.

Guess thats the way it works!

>-----Original Message-----
>I would start by guessing that the merge main documents may be using
[quoted text clipped - 38 lines]
>
>.

Reply to this Message