Others

Fix Access Hyperlinks Not Working After Microsoft 365 Restart

Maira MehtabMaira Mehtab Nov 2, 2026 869 views

Question details

Hyperlink fields generated via VBA in Microsoft Access stop functioning correctly after restarting Microsoft 365, affecting database distribution and Excel exports.

How to Fix Access Hyperlinks Not Working After Restarting Microsoft 365
Product
Microsoft Access
Device & OS
not provided
Scenario
Users are creating VBA-generated hyperlink fields in an Access database that is frequently exported to Excel for management review.
Observed behavior
The URLs appear valid but fail to open upon clicking after the Access application is restarted. They only function when users specifically select 'Open link in new tab'.
Before you start

Before applying these workarounds, ensure you have backed up your Access database and verify that your default web browser is properly configured in your Windows settings.

Solution 1Recommended

Store Web Addresses as Plain Text Fields

Converting Access hyperlink fields to plain text provides better stability and ensures URLs remain intact and functional when exported to spreadsheet software.

Access hyperlink fields can sometimes lose their internal formatting or browser association. By using standard text fields combined with a VBA script, you bypass these native formatting issues entirely.

1
Open Table Design View

Launch Microsoft Access and open the database table containing the problematic hyperlink field in Design View.

2
Change Data Type

Select the hyperlink field and change its 'Data Type' from 'Hyperlink' to 'Short Text' or 'Long Text', depending on the expected length of your URLs.

3
Save Table Changes

Save and close the table. Your existing hyperlinks will now be stored as plain text strings.

4
Use VBA to Open Links

On your Access form, add a command button or an OnClick event to the text box, and use the 'Application.FollowHyperlink' VBA command or PowerShell to open the text value in the default browser.

Store Web Addresses as Plain Text Fields
Export Advantage: Exporting plain text URLs to Excel prevents formatting corruption and allows users without Access to view and convert the links easily.
Free Microsoft Office alternative

Easily View and Manage Exported Database Records with WPS Office

When management prefers viewing Access data in Excel, WPS Spreadsheet offers a highly compatible, free, and lightweight alternative. It seamlessly handles exported CSV and XLSX files, ensuring your plain-text URLs and database exports remain fully functional and easy to navigate.

  1. 1. Download and Install: Get WPS Office for free from the official website and install it on your computer.
  2. 2. Open Exported Database Files: Launch WPS Spreadsheet and open the .xlsx or .csv file you exported from your Access database.
  3. 3. Manage Your Links: Interact directly with your plain text URLs, converting them to active hyperlinks to navigate directly to the intended web addresses.
Seamlessly open, edit, and save exported Microsoft Excel formats (.xlsx, .csv).Automatically convert plain text URLs into clickable hyperlinks within your spreadsheets.Lightweight installation with a familiar, easy-to-use tabbed interface.Completely free to use with comprehensive data management and filtering tools.
QA img-9

Frequently Asked Questions

Why do Access hyperlinks stop working after restarting the application?

Hyperlink fields in Access, especially those generated via VBA, can sometimes lose their internal URL structure or association with the default system browser upon restart, causing them to become unresponsive.

Will changing hyperlink fields to plain text affect my database forms?

Changing the data type will convert native clickable links into standard text on your forms. However, this improves overall stability. You can restore clickability by adding a simple VBA command like Application.FollowHyperlink to the field's OnClick event.

How can I ensure my Access links work when exported to Excel?

Exporting URLs as plain text fields is the most reliable method. Once opened in spreadsheet software like Excel or WPS Spreadsheet, these text-based URLs are preserved perfectly and can easily be activated as clickable links.

Does the 'Open link in new tab' right-click option permanently fix the problem?

No, right-clicking to open a link in a new tab is only a temporary user workaround. For a permanent fix, especially when distributing the database to other users, switching to plain text fields is strongly recommended.