Fix Access AddFromOutlook After Splitting a Contacts Database
Question details
The user needs to restore the AddFromOutlook command in an Access Contacts database after splitting it.

- 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.
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.
Trust the Access Front-End and Enable Its Content
Use this solution when Access security may be blocking the macro or code behind AddFromOutlook.
Open the front-end database file in Access rather than opening the shared back-end directly.
If the Access message bar displays a security warning, select Enable Content only if you trust the database and its source.
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.
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.
Close and reopen the local front-end, then select AddFromOutlook in the Contacts database.

Check Outlook References, Database Objects, and Linked Tables
Use these checks if AddFromOutlook still fails after the front-end is trusted.
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.

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.




