If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! -- Wordmerger |
#2
|
|||
|
|||
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
|
|||
|
|||
Problem connecting to data source on network drive
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. Wordmerger;467939 Wrote: 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 |
Thread Tools | |
Display Modes | |
|
|