Office Settings & Configuration

How to Fix Access 2019 Add-In Manager Security and Registry Errors

Adam DavisAdam Davis Nov 2, 2026 870 views

Question details

Users are unable to install add-ins in Microsoft Access 2019 due to security permission blocks and missing registry expressions in the Add-In Manager.

How to Fix Access 2019 Add-In Manager Security and Registry Errors
Product
Microsoft Access 2019
Device & OS
not provided
Scenario
Installing or configuring add-ins via the Access 2019 Add-In Manager.
Observed behavior
Access reports insufficient security permissions during add-in installation, and the Add-In Manager flags a registry setting that lacks a macro or function name expression.
Before you start

Verify that you are logged into Windows with an administrator account, as resolving Add-In Manager and Click-to-Run configuration issues requires elevated system privileges.

Solution 1Recommended

Perform an Online Repair for Office Click-to-Run

Running a full Online Repair is the most effective way to fix corrupt Office Click-to-Run configurations that block add-in permissions.

Because Microsoft Office 2019 Professional Plus utilizes a Click-to-Run architecture, local file corruption or broken background services can trigger false security permission errors across all add-ins.

1
Open Windows Control Panel

Press the Windows key, type 'Control Panel' in the search bar, and press Enter to launch the application.

2
Navigate to Programs and Features

Click on 'Programs', then select 'Programs and Features' to view your installed applications.

3
Modify Microsoft Office Installation

Scroll down to locate 'Microsoft Office 2019 Professional Plus', right-click on it, and select 'Change'.

4
Execute the Online Repair

Select the 'Online Repair' option in the dialog box and click 'Repair'. Wait for the process to completely reinstall core components and restart your computer before testing Access.

Perform an Online Repair for Office Click-to-Run
Free Microsoft Office alternative

Looking for a Lighter, Error-Free Office Suite?

While Microsoft Access is a powerful database management tool, encountering complex Click-to-Run registry errors and security blocks can disrupt your workflow. If your daily tasks primarily involve word processing, spreadsheets, and presentations, WPS Office provides a lightweight, highly compatible alternative without the heavy registry dependencies.

Fully compatible with Microsoft Word, Excel, and PowerPoint file formatsLightweight installation without complex Click-to-Run background servicesFree to use with a highly familiar, intuitive user interfaceSeamless migration of your existing documents, spreadsheets, and PDFs
microsoft office alternative - wps office

Frequently Asked Questions

Why does Access 2019 say I have insufficient security permissions for add-ins?

This typically occurs when your Windows user account lacks the administrative rights necessary to modify the Windows Registry, or when background policies in the Click-to-Run environment restrict external add-in installations.

What does 'lacks a macro or function name expression' mean in the Add-In Manager?

This error means that the specific registry key responsible for launching the add-in is either corrupt or completely missing the command string required to execute the add-in's core functions.

Will performing an Online Repair delete my existing Access databases?

No, performing an Online Repair only resets the core Microsoft Office application files and system registry keys. Your personal database files (.accdb) and internal records remain entirely unaffected.