Reply
 
Thread Tools Display Modes
  #1   Report Post  
Wordmerger Wordmerger is offline
Junior Member
 
Posts: 6
Default Problem connecting to data source on network drive

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!
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Problem connecting to data source on network drive

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


  #3   Report Post  
Wordmerger Wordmerger is offline
Junior Member
 
Posts: 6
Default

This problem is solved.
For those of you who have the same issue: after I added the path to the data source as a trusted location in the Internet Explorer, the connection could be established without a problem.
One more issue left, but I'll ask your help about that in a different post.
Grtz.


Quote:
Originally Posted by Wordmerger View Post
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!
  #4   Report Post  
Wordmerger Wordmerger is offline
Junior Member
 
Posts: 6
Default

Hi Doug,

Thanks for your help.
I found the answer in this KB article: http://support.microsoft.com/kb/834699/en-us



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Source Problem MF Scheetz Mailmerge 4 April 12th 07 02:52 PM
Can't select data source on a mapped network drive Microsoft Newsserver Mailmerge 3 February 9th 07 06:47 AM
Mail Merge & Data Source not connecting patricia.ayling Mailmerge 3 April 13th 06 09:42 AM
Problems connecting to Excel data source maryj Mailmerge 1 March 31st 06 09:22 PM
Using mapped drive as data source Paul van Peperstraten Mailmerge 1 December 1st 04 01:59 PM


All times are GMT +1. The time now is 06:05 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"