merge doc opening message

A

accdev

When I open a document that is merged from Access, I get a message that begins:
Opening this document will run the following SQL command. Select * form
'queryname'.... Is there any way to prevent this message from appearing?
 
J

Jean-Guy Marcil

accdev was telling us:
accdev nous racontait que :
When I open a document that is merged from Access, I get a message
that begins: Opening this document will run the following SQL
command. Select * form 'queryname'.... Is there any way to prevent
this message from appearing?

Try deactivating

"Update Automatic links at Open" under the General tab of the Options...
dialog from the Tools menu.

Don't know if it applies to those types of links...

Keep in mind that this is an Application wide setting (i.e., you will have
to update links manually, or, by using Print preview if the setting to
updates fields is active under the Print dialog).

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org
 
A

accdev

No luck....message still came up. I found a program on the web that I
modified to create this particular word doc. I contacted the person who
designed it and she said the message doesn't appear for her users and she
didn't do anything to exclude it....there must be a checkmark somewhere?
 
D

Daniele Pinai

You must insert a new DWORD value in regedit
HKey_Current_User / Software / Microsoft / Office / 11.0 / Word /
Options

The Values is

SQLSecurityCheck set it to 0 ( zero )
Bye bye
 

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