Word 2003
HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Word\Options

"SQLSecurityCheck"=dword:00000000
1. Start Registry Editor.
2. Locate and then click the following registry key:
HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Word\Options
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  
7. Click OK.

Greetings chestera,

You may refer to http://support.microsoft.com/?kbid=825765 for reference. :)

More information for your knowledge:

CAUSE
The prompt that is described in the "Symptoms" section is by design.

This prompt exists in all later versions of Microsoft Office and was introduced in Office XP Service Pack 3. This prompt was added in the products listed in the "Applies to" section to make mail merge more secure. If you click Yes when you receive the prompt, you let code run on your computer. A malicious user may be able to craft a SQL query that is designed to steal or to destroy data that you have access to. If you click No when you receive the prompt, you do not let code to run.

Note Setting DisplayAlerts=none through VBA suppresses the prompt when the file is opened by using VBA, but uses the NO option to open the document and no data is attached to the mail merge main document.

pc idiot

The app is on a number of machines so changing the registry not an option we don't had admin rights either.

To supress the prompt DisplayAlerts=none is that the same as Docmd setwarnings False

chestera

Hi chestera,

Thanks for the feedback. Here's another solution which u may try:

To determine if you are using any global templates, in Word go to Tools/Templates and Add-Ins and see if there are any global templates or add-ins listed. If so they are located in one of your Startup folders. The location of the Word\Startup folder can be found under Tools/Options/File Locations and the Office\Startup folder can be found in the Office installation path..

Take a look in each folder and if you find more than one file move them one at a time and try duplicating the error after each file is moved out of the folder until you determine which one is causing the problem.

Another workaround, please backup your files on a portable thumbdrive before proceeding:

Obtained from a user who had problem and solved when performed the below workaround.
Following instructions from Word-Tools/ Templates and Add Ins I found two global templates:- MyobMn97.dot and HTML.WLL
Only MYOB one was ticked.
I did a search from explorer and found MyobMn97.dot in two STARTUP folders:-
C:\......\OFFICE11\STARTUP and C:\Programfiles\MicrosoftOffice\Office\STARTUP
Deleted from both startup folders and problem solved. Did not touch HTML.WLL

pc idiot

Help most appreciated I will get back to you. I will try some of your suggestions

chestera

pc idiot

Tools/Templates the addins list box is empty. C:\.......Office11\Startup Empty. C:\....Office no Startup folder

chestera

pc idiot

Went to the microsoft web site http://support.microsoft.com/?kbid=825765 . It appears this is the only work around. As stated it's not an option for us. Looks like we will have to live with it.

chestera

pc idiot

Just changed the Registy and it works fine. Many thanks for your help. I will accept your last comment all the best

chestera

Thanks chestera,

Probably u might need to have the administrator help on this issue. I've friends working in big companies and if this is a microsoft KB issue, normally the engineers will assist in resolving the issue. Thanks again chestera, am glad it resolve ur issue.