opening this document will run the following sql command

T

Tom Hall

Office 2003:

Today, for the first time, I've started getting the following annoying
message box every time I open a Word document, or even when I create a new
document from scratch:

opening this document will run the following sql command

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

The line below this line in the dialog box is blank and if I close the
document, I am not prompted to save anything.

Running Detect and Repair does not correct the problem.

Reverting to older versions of Normal.dot does not correct the problem.

This computer is not networked, Office 2003 was installed from original CDs
and I am the only user of this computer.

I use Word almost every day, and each day's work is backed up to an
external drive.

Researching the text of the message led me to this:

http://support.microsoft.com/kb/825765

but I am reluctant to try it because of the warning attached to the
information. It also says that this message is encountered when I open a
mail merge document that is linked to a data source.

I have never used mail merge since installing Office 2003. I know nothing
about VBA and do not use programming code other than simple, basic Word
macros which I have written myself.

My AVG Professional 8.0 antivirus is kept up-to-date. I routinely apply all
Windows patches through Windows Update.

The only unusual event that I have noticed here was that last night when I
shut down the computer, Windows prompted me that there were updates ready
to apply and offered me the option of applying them before shutting down
the computer. As yesterday was Patch Tuesday, I assumed that Windows had
downloaded these updates automatically as the system is configured to do.
Usually I go to Windows Update myself and manually download and install
updates, but I was busy with a number of things yesterday and so did not
visit Windows Update. I allowed Windows to install the updates before
shutting down because I assumed that these updates had been downloaded by
Windows in the absence of any action by me.

Further research has led me to the discovery that one of the patches
applied was to Word 2003 (KB950241). I removed this update and the problem
went away.

I spent an hour on the phone with a Microsoft technician only to eventually
be told that a technician from the "Word department" would have to call me
back. As the security update is flagged as critical, I cannot block its
download and installation.

For the time being, my only recourse is to use the registry hack provided
in http://support.microsoft.com/kb/825765, but for obvious reasons I'm not
comfortable with this arrangement.

I would really appreciate help from any Word MVP out there who can draw a
bead on this issue.


Tom
 
D

Doug Robbins - Word MVP

Either put up with the message or modify the Registry and the KB article
mentions.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
 
T

Tom Hall

Confirming I get the same problem - after the same updating event.

I got a callback yesterday from Microsoft tech support, and the only thing
they had to offer me was the registry hack described in the above link.
They acknowledged that it wasn't an ideal solution to the problem and
indicated they would continue researching the issue and contact me if they
came up with a better solution.



Tom
 
J

Josh

What if I try the registry and navigate to it but am missing the final
"options" choice. This is what I see -
HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Word

Is that right?
 
R

Red VonBaron

One point and a question (or two)...

Point:
Doug - Please reread the original post. I have the same 'problem'. I don't use mail merge, never have. The main question asked is WHY is this occuring. Understanding was asked NOT the myriad other posts asking simply "How do I turn this thing off?" (which compromises security, actually is not a recommended solution etc.)

The effort put into the original post by Tom surely warrants a better response from you than the canned and oft repeated on virtually every other forum I've found where you've posted.

Question(s):
#1 - In addition to WHY - WHERE can I find this SQL statement/code in my doc? There are no macros in the doc, no addins loaded, no VBA or MS scripts etc.

#2 - I did receive a doc where it appears a data load was in it however it seems not for a mail merge rather a TOC. The select is referencing a local (mapped drive likely) word doc as the source. Also, the doc footer claims there are 4 pages to it but all I get is a single page regardless of what I answer. I've searched all over the doc (props, tools, scripts ) and can't find the code/statement nor a live field which I would assume is linking to the statement in order to load the data. Now what?

Regards,
Red
 
D

Doug Robbins - Word MVP

Now, wait a minute. I do NOT work for Microsoft. Like everyone else here,
I am a volunteer who gives up my time to try and help people and in this
case, I know of no better response.

I do not know why the message appears when the document is not a mail merge
main document, other than there must be something in the document, and I
know not what it is, that is triggering the message. I am guessing that it
is something to do with a security update, so blame the "script kiddies".

As one of the other posters to this thread mentioned, the only thing that
Microsoft support could come up with was the recommendation to make the
registry change that is covered in the link that I posted.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
 
T

Tom Hall

I do not know why the message appears when the document is not a mail merge
main document, other than there must be something in the document

How could there be "something in the document" when the message appeared
even when Word was opened with a blank document based on normal.dot?


Tom
 
D

Doug Robbins - Word MVP

There can be all sorts of things in Normal.dot. See what happens if you
close Word, rename normal.dot to normal.old and then restart Word.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top