Hi. I´ve got this message EVERY SINGLE TIME I open a merged Word document
with data source from an Access database:
"Opening this document will run the following SQL command
SELECT * FROM TableName
Data from your database will be placed in the document. Do you want to
continue?"

This message is really annoying to me, so please help me to find a way to
stop it from appearing
Thanks

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

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"LPC" wrote in message
news
Hi. I´ve got this message EVERY SINGLE TIME I open a merged Word document
with data source from an Access database:
"Opening this document will run the following SQL command
SELECT * FROM TableName
Data from your database will be placed in the document. Do you want to
continue?"

This message is really annoying to me, so please help me to find a way to
stop it from appearing
Thanks

"Suzanne S. Barnhill" wrote:

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

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"LPC" wrote in message
news
Hi. I´ve got this message EVERY SINGLE TIME I open a merged Word document
with data source from an Access database:
"Opening this document will run the following SQL command
SELECT * FROM TableName
Data from your database will be placed in the document. Do you want to
continue?"

This message is really annoying to me, so please help me to find a way to
stop it from appearing
Thanks



From what I understand the message is programmed to be there as a security
measure and if I don't feel qualified to edit my registry, then I'm just
stuck with it. Am I correct?
If so, I guess all my recipients will get to opem my data base or be annoyed
by the message. Surely there must be a way to avoid this annoyance.
Thanks

Editing the Registry is not that daring a venture! Nor do I find the message
that much of a hassle myself.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Jimsolt" wrote in message
...


"Suzanne S. Barnhill" wrote:

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

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so
all may benefit.

"LPC" wrote in message
news
Hi. I´ve got this message EVERY SINGLE TIME I open a merged Word
document
with data source from an Access database:
"Opening this document will run the following SQL command
SELECT * FROM TableName
Data from your database will be placed in the document. Do you want to
continue?"

This message is really annoying to me, so please help me to find a way
to
stop it from appearing
Thanks



From what I understand the message is programmed to be there as a security
measure and if I don't feel qualified to edit my registry, then I'm just
stuck with it. Am I correct?
If so, I guess all my recipients will get to opem my data base or be
annoyed
by the message. Surely there must be a way to avoid this annoyance.
Thanks

Perhaps I would find the message "non-hassling" also, but I'm concerned with
what happens when a recipient gets the message. On a copy I sent to myself I
got the message, and I could open the data base. Should I assume another
recipeint would 1) get the message and/or 2) not have access to the database?
Thanks.

"Suzanne S. Barnhill" wrote:

Editing the Registry is not that daring a venture! Nor do I find the message
that much of a hassle myself.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Jimsolt" wrote in message
...


"Suzanne S. Barnhill" wrote:

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

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so
all may benefit.

"LPC" wrote in message
news Hi. I´ve got this message EVERY SINGLE TIME I open a merged Word
document
with data source from an Access database:
"Opening this document will run the following SQL command
SELECT * FROM TableName
Data from your database will be placed in the document. Do you want to
continue?"

This message is really annoying to me, so please help me to find a way
to
stop it from appearing
Thanks



From what I understand the message is programmed to be there as a security
measure and if I don't feel qualified to edit my registry, then I'm just
stuck with it. Am I correct?
If so, I guess all my recipients will get to opem my data base or be
annoyed
by the message. Surely there must be a way to avoid this annoyance.
Thanks

Hi ?B?Smltc29sdA==?=,

but I'm concerned with
what happens when a recipient gets the message. On a copy I sent to myself I
got the message, and I could open the data base. Should I assume another
recipeint would 1) get the message and/or 2) not have access to the database?

There's nothing you can do to control what the recipient gets, in this respect.
This is a security measure for the individual machine/user-profile. If the
recipient uses mail merge regularly, they'll be familiar with the message (or
have turned it off in the Registry). If you have to assume they're not, you
might put a link to the KB article in your "covering message".

The only way to NOT have the message display is to send the files without a link
to the data source. Then have macro do the linking when the document is opened.
Of course, then you risk running into the Macro security messages, unless you've
digitally signed your code, and the recipient "trusts" your digital signature.

Blame it on all the people who get a kick out of invading other people's
machines. All Microsoft is trying to do is protect those using their software.

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 :-)