Opening merge docs: Any info on registry value SQLSecurityCheck?

[Zweitze de Vries]

Hi all,

When I open a merge doc, I get the warning "Opening this will run ...", as
described in
http://support.microsoft.com/?kbid=825765
The security warning asks if I want to continue, offering Yes or No.
Answering will execute the command, No will not run the command, but
continue anyway (!?).

The KB article mentions a workaround, by setting the registry value
SQLSecurityCheck to 0. This prevents the dialog, but assumes that the user
answered No. Is it possible to answer Yes (execute the command)?

I looked up the registry value in REGKEY.XLS of the resource kit, but this
only mentions the default value: 1. That value shows the dialog. Does anyone
know of a value that prevents the dialog, and answers Yes instead?

Thanks

 

[Cindy M -WordMVP-]

Hi Zweitze,

When I open a merge doc, I get the warning "Opening this will run ...", as
described in
http://support.microsoft.com/?kbid=825765
The security warning asks if I want to continue, offering Yes or No.
Answering will execute the command, No will not run the command, but
continue anyway (!?).

The document is opened, but the connection to the data source is lost.

The KB article mentions a workaround, by setting the registry value
SQLSecurityCheck to 0. This prevents the dialog, but assumes that the user
answered No. Is it possible to answer Yes (execute the command)?

If you set the Registry key, then the SQL security check is disabled. It
assumes the user answers "Yes". When a mail merge document is opened, the
connection to the data source is retained.

If you automate mail merge with DisplayAlerts set to False, and with the
security check enabled, the document will open without a prompt. But the
assumption will be that the user has answered "No" and the data source will
have been disconnected.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.mvps.org/word

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

 

[Zweitze de Vries]

The document is opened, but the connection to the data source is lost.

Well, the message suggests you can abort the opening. I think this is very
misleading.

If you set the Registry key, then the SQL security check is disabled. It
assumes the user answers "Yes". When a mail merge document is opened, the
connection to the data source is retained.

No kidding? I should have tested this with more care...

If you automate mail merge with DisplayAlerts set to False, and with the
security check enabled, the document will open without a prompt. But the
assumption will be that the user has answered "No" and the data source will
have been disconnected.

Thanks.

 

[Cindy M -WordMVP-]

Hi Zweitze,

Well, the message suggests you can abort the opening. I think this is very
misleading.

I agree, and I so stated during beta. But this feature was added so late that
no changes (except for anything earth shattering) could be made. So there we

No kidding? I should have tested this with more care...

Well, be sure to let me know if it's NOT working for you when you
carefully test it again

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
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