Fix Access Hyperlinks Not Working After Microsoft 365 Restart
Question details
Hyperlink fields generated via VBA in Microsoft Access stop functioning correctly after restarting Microsoft 365, affecting database distribution and Excel exports.

- 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 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.
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.
Launch Microsoft Access and open the database table containing the problematic hyperlink field in Design View.
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.
Save and close the table. Your existing hyperlinks will now be stored as plain text strings.
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.

Repair the Microsoft Office Installation
If the hyperlinks are failing due to a corrupted Office or Windows registry configuration, running an online repair might resolve the underlying issue.
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. Download and Install: Get WPS Office for free from the official website and install it on your computer.
- 2. Open Exported Database Files: Launch WPS Spreadsheet and open the .xlsx or .csv file you exported from your Access database.
- 3. Manage Your Links: Interact directly with your plain text URLs, converting them to active hyperlinks to navigate directly to the intended web addresses.

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.




