Book

Suggestions


Enter your email address:

Delivered by FeedBurner


Home Page

Bloglines

1906
CelebrateStadium
2006

OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal









Subscribe here
Add to My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com


  Monday, June 15, 2009 – Permalink –

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?


SQL Warning

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

Labels:


<Doug Klippert@ 3:15 AM

Comments: Post a Comment