I want to purchase time with an Access/Word merge specialist

Question

I have a Access database that has a button that opens a DocumentMenu that is on a networked drive. That Menu hyperlinks to documents that, when clicked, are supposed to (and did, in Office2007) open forms that are connected to tables in my Access database. The form then can merge info from that table.

It worked fine in Office 2007, but in 365 Access it keeps changing the links to delete , when opened in the database. When opened in Word alone, it works.

I'd pay an expert to solve this for me.

Answer 1

Hello Durst Law

Thanks for the detailed explanation.

Please note that Microsoft Q&A is a public, user‑based support forum and does not provide a way to purchase consulting time directly. If you would like hands‑on assistance, you may want to look for an Access/Office automation consultant through the Microsoft partner directory, or consider hiring a specialist through a professional hiring platform. You may also want to keep in mind George’s suggestion that "Check the credentials of anyone who responds and ask for examples of work they’ve done.”

Based on the behavior you described, this is likely a common compatibility issue when moving from Office 2007 to Microsoft 365. Word 365 (and newer versions) has much stricter default behavior for hyperlinks, especially when the Word document is opened from inside Access and the files live on a networked drive. Word automatically updates/rewrites hyperlinks on open or save, which is why the links work fine when you open the document directly in Word, but get changed or broken when launched via your Access button.

Common approaches include avoiding the Access Hyperlink data type, storing file paths as plain text, using UNC paths instead of mapped drive letters, or opening documents via VBA instead of clicking hyperlinks directly.

You can also try the following steps. First, open the DocumentMenu Word document directly in Word, then go to File > Options > Advanced. Scroll down to the General section and select Web Options. On the Files tab, uncheck “Update links on save”, then select OK, select OK again, and save and close the document.

Next, update all hyperlinks to use UNC paths instead of mapped drive letters. For example:

Address: \server\share\path\YourDatabase.accdb

SubAddress: Form YourFormName

(Please note the single space after the word Form.)

Additionally, add the network folder as a Trusted Location in both Access and Word by going to File > Options > Trust Center > Trust Center Settings > Trusted Locations, then select Add new location, check “Subfolders of this location are also trusted”, and ensure that network locations are enabled.

Hope this information is helpful. If you need further assistance, feel free to leave a comment.

---

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.  

Answer 2

The described behavior is a compatibility issue between the legacy Word–Access merge setup and newer Microsoft 365 Access/Word versions. The supported and recommended path is to update Office to the latest build where known Access/Word integration issues are fixed, then re-establish the merge links using the current tools.

Follow these steps:

1. Update Microsoft 365 / Office on all machines
   The fix for several Access issues (including Word Mail Merge integration problems) is delivered via Office updates and must be installed on every PC running Access.
   • Install the latest Office updates as described in Install Office updates (linked from the article below).
   • Ensure Word is closed so that any fixes for the Word–Access merge are fully applied.
2. Confirm the Word Mail Merge issue is fixed
   There is a known issue where using the Word Merge command from Access to link to an existing Word document fails with “The ShowMe command is not available in Word,” and the merge aborts. This affects Access for Microsoft 365, Access 2019, and Access 2021, and is now fixed in all impacted channels.
   After updating Office and restarting Word/Access, re-test the merge from Access using the Word Merge command with an existing document.
3. Recreate or repair the merge documents in the current version
   Because the original setup was built in Office 2007, the field links and paths inside the Word documents may not be fully compatible with current Access/Word behavior. After updating Office:
   • Open each merge document directly in Word and confirm it works with the data source.
   • Then, from Access, use the Word Merge command to re-link the document to the current database/tables so Access writes the paths and connection information in the format expected by Microsoft 365.
4. Check for network-path-related issues
   Since the documents are on a network drive, ensure that network access is stable and that mapped-drive policies are not interfering. Access is sensitive to network interruptions. If there are errors like “Your network access was interrupted,” review mapped drive Group Policy and consider using UNC paths instead of mapped drive letters.
5. Monitor ongoing Access issues
   For any additional Access/Word integration or performance issues, use the consolidated “Fixes or workarounds for recent issues in Access” page, which links to current known issues and their resolutions, and the Access Developer Blog for newly published fixes.

For specialized, paid assistance, use the official community and support channels referenced below (Access Tech Community, Access Forum on Answers) to locate consultants or to open a support case, since direct commercial engagement is not handled here.

---

References:

• Word Mail Merge fails when using existing Word document
• Fixes or workarounds for recent issues in Access
• Error in Access when opening a database on a network file share
• Access error "Your network access was interrupted" when using a mapped drive