SQL Warning in Word

Merge Ahead!

When you open a Word  mail merge main document that is linked to a data source, you may receive the following message:

Opening this will run the following SQL command:

SELECT * FROM C:\file_name.log

Data from your database will be placed in the document. Do you want to continue?

This message helps protect you from unintentionally sending data to a malicious user.
To suppress this message, you must first create the following registry key:

1. Open Registry Editor.
2. Locate, and then click the following registry key:
   
   HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Word\Options
   
   (Use 12.0 for Word 2007)
   
   
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

See
Microsoft KB 825765

Installing Office XP SP3 appears to cause the same problem. For Word 2002 (XP also known as 10.0) you need to place the registry key in: HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Word\Options

(Thanks to Brian Livingston at WindowsSecrets.com for pointing the way to a solution)



See all Topics