Find Data Source Error Word and Excel 2003

[Scott Miller]

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.

 

[Peter Jamieson]

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

 

[Scott Miller]

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!