Thread
:
Problem connecting to data source on network drive
View Single Post
#
4
Wordmerger
Junior Member
Posts: 6
Hi Doug,
Thanks for your help.
I found the answer in this KB article:
http://support.microsoft.com/kb/834699/en-us
Quote:
Originally Posted by
Doug Robbins - Word MVP
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
If you click No when that message appears, the data source will be detached
from the main document.
--
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, originally posted via msnews.microsoft.com
"Wordmerger"
wrote in message
...
Hi,
For a client of us, I created a template in Word 2007.
This is a main mailmerge document that connects to a data source on the
network.
The data source is a CSV file.
I connected to the data source manually from within the template and
that worked OK.
The second time I opened the template I got the message that a SQL
command was being executed on the (appropriate) file, so it looked as
if the connection was made.
But once inside the main document, there was no connection and I had to
connect manually again.
My client doesn't want to do this (and I think it should not be
necessary).
Has anybody got a clue what causes this behavior and how I can fix it?
I read a post (from april 2009) with almost the same problem, but I
couldn't find out if the solution has been posted too.
Thanks in advance!
--
Wordmerger
Reply With Quote
Wordmerger
View Public Profile
Send a private message to Wordmerger
Find all posts by Wordmerger