Friday, March 18, 2016

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:


    (Use 12.0 for Word 2007)

  3. Click Edit, point to New, and then click DWORD Value.

  4. Under Name, type:


  5. Double-click SQLSecurityCheck.

  6. In the Value data box, type:

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 for pointing the way to a solution)

See all Topics

Monday, March 07, 2016

PowerPoint Bloats Word

Diet tips

For various reasons, it can be helpful to send a PowerPoint show to Word. You can have great looking handouts and be able to format the document in ways that are not possible in PowerPoint.

The problem can be the size of the resultant file.

One of the easier, more practical ways to slim the doc down is to break the OLE links.
The size of a Word document may be 20 to 50 times larger than a PowerPoint presentation when you send the presentation to Word.
  1. Start PowerPoint.

  2. On the File menu, point to Send To, and then click Microsoft Office Word.

  3. Click Paste link, and then click OK.

  4. In the resulting Word document, click Links on the Edit menu.

  5. Select all the links that are listed, and then click Break Link.

  6. Click Yes when you are prompted.

  7. Save the Word document.
When you eliminate the OLE overhead, you can reduce the size of the Word document by 90 percent
 Size of Word Document

See all Topics

Saturday, March 05, 2016

Unicode and Other Characters

Why's A 65?

Underlying the intriguing prose spread across the monitor screen are numbers and more numbers.

Joel Spolsky, a New York software developer has written a combination history/tutorial about this numeric-literary liason.

He calls it:
"The Absolute Minimum Every Software Developer Absolutely, Positively Must Know About Unicode and Character Sets (No Excuses!)"
Unicode and Character sets

See all Topics

Tuesday, March 01, 2016

Grammar Rules

Could Of or Could Have?

This web site sells a grammar and spell checker, but they also have a compendium of rules for free.

"Looking for a specific rule to help you in your writing? Trying to decide between two similar words? A grammar checker helps you, but does not tell you why. Grammar checkers also miss many errors, especially those having to do with names, punctuation, sounds, and style.

Some of you may have a full grammar textbook stored on your disk somewhere, but it is a nuisance to access and use.

Grammar Slammer takes care of both problems in an easy-to-use format. Grammar Slammer contains the rules and tips you need to write your best and make yourself clear. Grammar Slammer uses the familiar Web Page format to make it easy to find what you are looking for. It even has an easy-to-use glossary to help with those grammatical terms you can't remember. It will truly Slam your Grammar Agony!"

Grammer Slammer

(Could of does not exist. Neither do should of, will of, or would of as verbs.)

See all Topics