How to add the DWORD value SQLSecurityCheck in Word/Options registery via Regedit?

Question

My MS Access program opens a mail merge Word document to prepare a document or a mail with Access data. To avoid an error explaining that the mail merge document is not foreseen for mail merge, I needed to add via Regedit the DWORD value SQLSecurityCheck in the registery HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Word\Options  

However, with the latest version of Windows and Office, I don't see anymore this registry key. What's the "workaround" solution for this new release?

Answer 1

Hi Jack,

As Doug suggested above, you only need to choose either set the SQLSecurityCheck in the Registry or install the add-in on your computer. As I noticed that you didn't have a clear understanding on how to add SQLSecurityCheck in the Registry, please try to follow the steps below to set up.

1: Press Window key + R and key in " regedit" in the dialog

2: Select OK to run Registry Editor

3: Locate the following  registry key: HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Word\Options

4: Right click on Option folder and create DWORD registry key

5: Rename the created key as " SQLSecurityCheck"

6:Double click on SQLSecurityCheck and set value data as 00000000, and click okay to save.

7: Restart your computer.

If the issue still exists, please also provide as the screenshot of your Office version. You can go to File > Account > Under Product Information to check it.

Notes: To protect your information, please remove any private information before you share the screenshots with us. Thank you.

Best regards,

Dihao

Answer 2

If what you are saying that the customer "activated" what was probably a trial version on the new PC, it might be best to remove all traces of the Office installation by downloading the fixit from the following article:

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

saving it to the new computer and then running it.

Then, after re-starting the computer, reinstall Office by logging into www.office.com/myaccount with the registered email address and click Install Office.

Answer 3

Thank you Doug for your assistance. However, it does not solve my problem.

When I use my MS Access (Access 2010)  with Word 2007, I can generate letters and mails.

What did I try? I installed your .dotm file in Word\STARTUP. I'm sure it is well installed, because when Word is open, I can't delete your .dotm file.

I suppress via Regedit the DWORD Value SQLSecurityCheck.

And then I have the "classic" error" explaining that my document isn't a MailMerge document. 

As you see I have no problems with all Windows and MS Access environments, except by 1 customer who has a very new PC. With the new version of Office, the app Winword.exe and Msacces.exe is not in c:\Program Files. It is stored in :

"C:\Program Files\WindowsApps\Microsoft.Office.Desktop.Access_16051.11901.20176.0_x86__8wekyb3d8bbwe\Office16\MSACCESS.EXE".

Also, when looking via Regedit  the registry HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Word\Options;. There is no  the registry HKEY_CURRENT_USER\Software\Microsoft\Office.

Answer 4

If you  set the SQLSecurityCheck in the Registry, you do not need to use the add-in.

What type of computer is that customer using?

Answer 5

i have been following along with this thread.  if have a new computer with Win 10 and office 365.

this is from the Word Account

i have modified the registry:

NOTE that i needed to create the Options Key.  none existed when i started.

it does not appear that this is the Word 365 key, (but who am i to know?)

do you have any other suggestions?

[PII is masked by Dihao Guo MSFT Support]