Word 2003 Security issues

[white605]

I am receiving the message "Opening this document will run the following SQL command" when automating word 2003 by using the run command and calling word with a macro.
MSFT site contains the following fix:

Microsoft Office Word 2003
HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Word\Options

"SQLSecurityCheck"=dword:00000000
1. Start Registry Editor.
2. Locate and then click the following registry key:
HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Word\Options
3. Click Edit, point to New, and then click DWORD Value.
4. Under Name, type:
SQLSecurityCheck
5. Double-click SQLSecurityCheck.
6. In the Value data box, type:
00000000
7. Click OK.

Since this disables all security checking of this type is there a better way to get around this new level of security that causes the run command not to fail, but to throw prompts to the user?
thanks
wjwjr

 

[rkolva]

I dealt with this a year ago and I think I resolved the issue by not saving the merge header to the document. That meant that as I run the merge routine I have to attach the merge header, or merge source, merge the doc, save it to a new file (if necessary) and then close the template without saving the merge header or merge source.

Hope that helps, if not post a reply and I'll dig through some projects to review what I came up with.

Ralph

 

[white605]

Thanks for the reply. I used the registry scheme that i posted and it worked fine, just dont know what else will jump out to bite me. I will give your method a try.
wjwjr