Fix Microsoft Access Hyperlinks After Uploading a Database to SharePoint
Question details
Identify why hyperlinks to network documents in an Access database stop working after the database is uploaded to SharePoint.

- Product
- Microsoft Access and SharePoint
- Device & OS
- not provided
- Scenario
- An Access database containing links to network documents has been uploaded to a SharePoint document library.
- Observed behavior
- Hyperlinks to network documents no longer work as expected after the upload.
Identify a link that fails and note any error message. Check your Office version and whether the link points to an HTTP or HTTPS address, a file path, or a mapped network drive.
Test the downloaded database and check its hyperlink paths
Use this approach to determine whether the failure is related to the stored path or access to the target document.
In the SharePoint document library, select the database and choose Download. Open the downloaded file in Microsoft Access on a local computer.
In Access, open the form or table containing the hyperlink and click it. Record the exact error message and whether the document opens.
Select the hyperlink and use Access's hyperlink editing option to inspect its address. Check whether it uses HTTP, HTTPS, a file path, or a mapped drive, and confirm that the path still points to the intended document.
Paste the stored address into a browser for a web link or into File Explorer for a network path. For a mapped drive, verify that the drive is available to the current user; use an accessible network path or update the hyperlink if the stored path is incorrect.

Compare the link in a blank Access database
Use a new database to help isolate a problem with the stored link from one specific to the original database.
Work with Office Documents in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with compatible Office documents. It can help you move everyday document work to WPS, but it does not repair Access databases or their hyperlinks.

Frequently Asked Questions
Can file hyperlinks work in a database downloaded from SharePoint?
Yes, file hyperlinks can work when the downloaded database is opened in Access, provided the target path is valid and the current user can access the network location.
Why does a mapped drive link work for one user but not another?
The drive letter may not be mapped to the same location for both users, or one user may lack access. Check the path in File Explorer under each account and update the hyperlink if needed.
How can I tell whether the stored link is the problem?
Create a blank database through File > New > Blank database, add a Hyperlink field, and test the same address. Compare the result with the link in the original database.
Does downloading the database from SharePoint fix its links automatically?
No. Downloading lets you test the database locally in Access, but you still need to check whether each stored address is correct and accessible.




