Word 2003 Run SQL? pop-up

[Leon Hoeneveld]

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

 

[Cindy M -WordMVP-]

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

 

[kemp]

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

 

[Cindy M -WordMVP-]

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