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

Hi NeilQuinnJr,

Glad to hear that the problem was fixed. If you have any other concerns, please feel free to post them in our community.

Best regards,

Dihao

Answer 4

Hello Doug,

Sorry for my late reaction. I couldn't contact my customer to get the software versions.

Here they are:

Windows 10 version 1809

Microsoft Office 365

Microsoft Word for Office 365 MSO (16.0.11929.20234) 32 bits

Microsoft Access for Office 365 (16.0.11929.20234) 32 bits

The programs WinWord.exe and MSAccess.exe are NOT installed in Program Files (x86) or Program Files.

MSAccess.exe is actually located at: "C:\Program Files\WindowsApps\Microsoft.Office.Desktop.Access_16051.11929.20254.0_x86__8wekyb3d8bbwe\Office16\MSACCESS.EXE"

10 days ago is was located at: "C:\Program Files\WindowsApps\Microsoft.Office.Desktop.Access_16051.11901.20176.0_x86__8wekyb3d8bbwe\Office16\MSACCESS.EXE"

Within Regedit I search for a registry key "Office" containing a registry key "Word" or "Access". I didn't found it!

So, to be clear there is NO registry key :

HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Word\Options  

or

HKEY_LOCAL_MACHINE | Software | Wow6432Node | Microsoft | Office | 16.0 | Word | Options

I have 2 problems:

1/ How can I add the registry key SQLSecurityCheck?

2/ To run my Access application I need to give some parameters in the Windows desk shortcut. The following is OK:

"C:\Program Files\WindowsApps\Microsoft.Office.Desktop.Access_16051.11929.20254.0_x86__8wekyb3d8bbwe\Office16\MSACCESS.EXE" C:\GIL\GIL26.accdb /runtime /excl /cmd c:\GIL

However, in this case I need to give the full path of MSAccess which may change depending on MS updates.

Thank in advance for your help.

Answer 5

Hello

Sorry for my late reaction. I couldn't contact my customer to get the software versions.

Here they are:

Windows 10 version 1809

Microsoft Office 365

Microsoft Word for Office 365 MSO (16.0.11929.20234) 32 bits

Microsoft Access for Office 365 (16.0.11929.20234) 32 bits

My MSAccess application is creating Word documents by Mail merge with Access data. So I need to add a registry key SQLSecurityCheck.

The programs WinWord.exe and MSAccess.exe are NOT installed in Program Files (x86) or Program Files.

MSAccess.exe is actually located at: "C:\Program Files\WindowsApps\Microsoft.Office.Desktop.Access_16051.11929.20254.0_x86__8wekyb3d8bbwe\Office16\MSACCESS.EXE"

10 days ago is was located at: "C:\Program Files\WindowsApps\Microsoft.Office.Desktop.Access_16051.11901.20176.0_x86__8wekyb3d8bbwe\Office16\MSACCESS.EXE"

Within Regedit I search for a registry key "Office" containing a registry key "Word" or "Access". I didn't found it!

So, to be clear there is NO registry key :

HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Word\Options  

or

HKEY_LOCAL_MACHINE | Software | Wow6432Node | Microsoft | Office | 16.0 | Word | Options

I have 2 problems:

1/ How can I add the registry key SQLSecurityCheck?

2/ To run my Access application I need to give some parameters in the Windows desk shortcut. The following is OK:

"C:\Program Files\WindowsApps\Microsoft.Office.Desktop.Access_16051.11929.20254.0_x86__8wekyb3d8bbwe\Office16\MSACCESS.EXE" C:\GIL\GIL26.accdb /runtime /excl /cmd c:\GIL

However, in this case I need to give the full path of MSAccess which may change depending on MS updates.

Thank in advance for your help.