Others

Fix Access AddFromOutlook After Splitting a Contacts Database

John WilsonJohn Wilson Nov 22, 2026 868 views

Question details

The user needs to restore the AddFromOutlook command in an Access Contacts database after splitting it.

Fix Access AddFromOutlook After Splitting a Contacts Database
Product
Microsoft Access and Microsoft Outlook
Device & OS
not provided
Scenario
A Contacts database has been split into a local front-end and a back-end containing shared tables.
Observed behavior
The AddFromOutlook command may no longer run after the database split.
Before you start

Identify the front-end file you use to open the Contacts database and the location of the shared back-end. Have Outlook available and note any error message that appears when you select AddFromOutlook.

Solution 1Recommended

Trust the Access Front-End and Enable Its Content

Use this solution when Access security may be blocking the macro or code behind AddFromOutlook.

1
Open the local front-end

Open the front-end database file in Access rather than opening the shared back-end directly.

2
Enable trusted content

If the Access message bar displays a security warning, select Enable Content only if you trust the database and its source.

3
Check trusted locations

Go to File > Options > Trust Center > Trust Center Settings > Trusted Locations. If appropriate, select Add new location and choose the folder containing the local front-end.

4
Review security settings

In Trust Center Settings, review Macro Settings and Add-ins settings for restrictions that could block the database's code or required add-ins. Follow your organization's security policy rather than enabling all macros globally.

5
Test the command

Close and reopen the local front-end, then select AddFromOutlook in the Contacts database.

Trust the Access Front-End and Enable Its Content
Trust only known files: A trusted location can allow database content to run without the usual security prompts. Use a controlled folder and trust only files from sources you know.
Free Microsoft Office alternative

Use WPS Office for Everyday Office Files

WPS Office is a free, lightweight, easy-to-use alternative for documents, spreadsheets, and presentations. Its familiar interface and Microsoft Office format support make it easier to move everyday files, though it does not repair or replace an Access database or its Outlook automation.

Work with compatible Microsoft Word, Excel, and PowerPoint file formatsView and manage contact lists saved as supported spreadsheet filesUse a familiar interface for everyday office tasksMove supported documents between Microsoft Office and WPS Office
microsoft office alternative - wps office

Frequently Asked Questions

Why might AddFromOutlook stop working after a database split?

The front-end may not be trusted, a required reference or macro may be unavailable, or linked tables and object locations may have changed. Check the Access security warning, VBA references, and Linked Table Manager.

Which database file should I put in a trusted location?

Place the front-end file that contains the forms, macros, and code in a controlled trusted folder. In Access, go to File > Options > Trust Center > Trust Center Settings > Trusted Locations to review or add the folder.

How do I check whether Access can find the back-end tables?

Open the front-end and go to External Data > Linked Table Manager. Check the table paths and refresh or relink any tables that point to the wrong back-end.

Does every Access database need an Outlook object library reference?

No. In the VBA editor, select Tools > References to check for missing references. An Outlook library reference is needed only if the code uses it directly.

Can WPS Office run the Access AddFromOutlook command?

No. WPS Office does not run or repair Access database automation. Use Access to troubleshoot the command; WPS can work with a contact list exported to a supported spreadsheet format.