A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Error Message following SQL command?



 
 
Thread Tools Display Modes
  #1  
Old November 6th, 2008, 03:58 PM posted to microsoft.public.word.mailmerge.fields
tomp
external usenet poster
 
Posts: 60
Default Error Message following SQL command?

I have mail merge documents created in Office 2002 XP. The database files
are all in MS Word and all are located on the network for everyone to use.
Ever since we got Office 2003 a new message appears when you open your
document.......

"Opening this document will run the following SQL command:

SELECT * FROM C:\Documents and Settings\username\file name

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

I have to select "yes" 2 times to bypass this message and work on the
document. There is nothing wrong with the mail merge. Only thing that is
annoying is you have to click "yes" twice to continue. Is there a way to
remove the warning messages?

Thank you,

Tom
  #2  
Old November 6th, 2008, 07:27 PM posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
Default Error Message following SQL command?

See the following Knowledge Base article for how to edit the Registry to
prevent the message from appearing:

"Opening This Will Run the Following SQL Command" Message When You Open a
Word Document - 825765 at:

http://support.microsoft.com?kbid=825765


--
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

"TomP" wrote in message
...
I have mail merge documents created in Office 2002 XP. The database files
are all in MS Word and all are located on the network for everyone to use.
Ever since we got Office 2003 a new message appears when you open your
document.......

"Opening this document will run the following SQL command:

SELECT * FROM C:\Documents and Settings\username\file name

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

I have to select "yes" 2 times to bypass this message and work on the
document. There is nothing wrong with the mail merge. Only thing that is
annoying is you have to click "yes" twice to continue. Is there a way to
remove the warning messages?

Thank you,

Tom



  #3  
Old November 7th, 2008, 06:18 AM posted to microsoft.public.word.mailmerge.fields
Graham Mayor
external usenet poster
 
Posts: 18,297
Default Error Message following SQL command?

There is a macro on my web site that will toggle the setting in the registry
http://www.gmayor.com/word_vba_examples.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Doug Robbins - Word MVP wrote:
See the following Knowledge Base article for how to edit the Registry
to prevent the message from appearing:

"Opening This Will Run the Following SQL Command" Message When You
Open a Word Document - 825765 at:

http://support.microsoft.com?kbid=825765



"TomP" wrote in message
...
I have mail merge documents created in Office 2002 XP. The database
files are all in MS Word and all are located on the network for
everyone to use. Ever since we got Office 2003 a new message appears
when you open your document.......

"Opening this document will run the following SQL command:

SELECT * FROM C:\Documents and Settings\username\file name

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

I have to select "yes" 2 times to bypass this message and work on the
document. There is nothing wrong with the mail merge. Only thing
that is annoying is you have to click "yes" twice to continue. Is
there a way to remove the warning messages?

Thank you,

Tom



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:13 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.