Word 2003 Run SQL? pop-up

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Leon Hoeneveld - 08 Dec 2004 16:07 GMT

I have a word document connected to a comma separated file.
In the file are merge fields.
In an application I write the content of the file and open
word to merge.

This does not work in Word 2003. The link with my connceted
file is lost.
When I open the word document manually I get a message
asking me to run an SQL-command. I think this is the
problem. I want Word to run the SQL command always, without
prompting me to do so. I cannot find the menuoption to
manage this.
Does anyone know how to make Word run SQL-command by
default.

(Word 2002 doesn't have this problem)

Thanks in advance,

L?on hoeneveld

Reply to this Message

Cindy M -WordMVP- - 10 Dec 2004 17:25 GMT

Hi Leon,

> When I open the word document manually I get a message
> asking me to run an SQL-command.

See this article

"Opening This Will Run the Following SQL Command" Message
When You Open a Word Document - 825765
http://support.microsoft.com?kbid=825765

You probably want to set the Registry key it mentions.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail

:-)

Reply to this Message

kemp - 22 Dec 2004 19:27 GMT

hi cindy:

thanks for the article link.

however, what to do in the situation where you can't change or don't find it
desirable to change the registry ?

do you know of any of any data source formats that don't trigger the
'Opening this will run the following SQL command' prompt?

thanks

kemp

> Hi Leon,
>
[quoted text clipped - 18 lines]
> follow question or reply in the newsgroup and not by e-mail
> :-)

Reply to this Message

Cindy M -WordMVP- - 25 Jan 2005 19:16 GMT

Hi =?Utf-8?B?a2VtcA==?=,

No, there's no way around this, other than changing the Registry. Or using VBA
(in an AutoOpen macro, for example) to link to the data source AFTER the
document has been opened.

> however, what to do in the situation where you can't change or don't find it
> desirable to change the registry ?
>
> do you know of any of any data source formats that don't trigger the
> 'Opening this will run the following SQL command' prompt?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)

Reply to this Message