Source File Off'97 vs '03

[RWN]

Have an xl source file that is used in a mail merge and is located on a network drive (at
work).
The Word template resides in the workgroup templates directory.
Prior to Off'03, once the merge was set up it functioned easily (user selected the
template-File->New) and away it goes.
In '03 it comes up with the "Opening this file...sql..Select * from" message - which is
fine, but;
on my machine it works - shows the directory/file (say ok and it proceeds).
On the user's machine it presents the message but the file name is shown with quotes and
an appended "$" sign - no directory is indicated.
Saying "ok" causes it to bring up the "Select Data Source" dialogue forcing the
re-selection of the file-which is a PITA for the user.
After that it works ok.

The differences are that;
- I have local admin rights
- I "manufactured" the Word template & XL workbook.

Would either of these differences cause the situation, or is there something else afoot
here that I (obv.) don't understand.

 

[Doug Robbins]

See the following Knowledge Base article:

"Opening This Will Run the Following SQL Command" Message When You Open a
Word Document - 825765 at:

http://support.microsoft.com?kbid=825765

The user's problem may result from their having at one time clicked on No
when the above message appeared.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[RWN]

Thanks Doug, but I guess I didn't explain it well enough.
I have no problem with the message-I was aware of the change (and the KB).
The problem is that it displays the filename with oddball quotes and an appended "$" sign
(no directory).

Saying OK brings up the "Select Data Source" dialogue.

Browsing and selecting it allows the merge to run.

The next day (it's run daily) the same thing happens.
It's as if it is loosing the connection to the source file.
As noted, it works ok for me.

I'm thinking now that the format of the file name in the warning box is giving me a hint
but I don't know what it is.
ex. the path and file name are -\\networkdrive\SourceFile.xls
The warning screen shows just`'SourceFile.xls$'`.

Guess I'll have to do some playing around as it appears I'm missing something (probably
the obvious!).

Again, thanks.

 

[Doug Robbins]

Has the user saved the main document after taking the necessary steps to
attach the datasource?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP