File Cannot Open

Fix an Access Database That Will Not Open for Coworkers

Phi Hung VoPhi Hung Vo Oct 10, 2026 869 views

Question details

Users need to resolve an issue where coworkers are unable to open a shared Microsoft Access database across a local network.

How to Fix an Access Database That Won't Open for Coworkers
Product
Microsoft Access
Device & OS
not provided
Scenario
Multiple coworkers are attempting to access a shared Access database with linked tables hosted on a network drive.
Observed behavior
The database fails to open or cannot locate the linked tables because the tables are mapped using a specific drive letter that differs or does not exist on the coworkers' computers.
Before you start

Ensure you have the exact Universal Naming Convention (UNC) network path to the server or shared folder hosting the backend database file, and verify that all coworkers have appropriate read/write network permissions.

Solution 1Recommended

Update Linked Table Paths to Use a UNC Path

Changing the linked tables from a mapped drive letter to a UNC network path ensures the database connects correctly regardless of individual computer drive letter assignments.

Mapped drive letters (like Z:\ or X:\) are specific to each user's computer setup. By using a UNC path (such as \\ServerName\SharedFolder), the database relies on a universal network location that remains consistent for all coworkers accessing the file.

1
Open Linked Table Manager

Open the Microsoft Access database containing the linked tables. Navigate to the 'External Data' tab on the top ribbon and click on 'Linked Table Manager'.

2
Select the tables to update

In the Linked Table Manager dialog box, check the boxes next to the tables whose paths need to be updated. You can click 'Select All' to update every linked table simultaneously.

3
Prompt for new location

Check the box labeled 'Always prompt for new location' at the bottom of the dialog window, then click the 'OK' button to proceed.

4
Select the backend database using the UNC path

A file explorer window will open. Do not use your mapped drive to locate the file. Instead, type the full UNC path (e.g., \\ServerName\SharedFolder\DatabaseName.accdb) into the file name bar, select the backend database file, and click 'Open'.

Update Linked Table Paths to Use a UNC Path
Linked Tables Refreshed: Microsoft Access will display a prompt confirming that all selected linked tables have been successfully refreshed using the new universal path.
Free Microsoft Office alternative

Explore WPS Office for Your Document and Data Needs

While Microsoft Access is required for specific relational database management, you can handle extensive data sets, reports, and daily office tasks efficiently with WPS Office. It is a powerful, lightweight, and completely free alternative for your Word, Excel, and PowerPoint files, ensuring smooth collaboration without complex network configuration issues.

  1. 1. Download the installer: Visit the official WPS Office website and click the 'Free Download' button to get the latest version for your operating system.
  2. 2. Install WPS Office: Run the downloaded executable file and follow the simple on-screen instructions to complete the installation.
  3. 3. Manage your data: Launch WPS Spreadsheets to open your exported database files (such as .csv or .xlsx) to instantly view and edit your data.
Highly compatible with standard Microsoft Office formats, including .docx, .xlsx, and .pptx.Includes a powerful Spreadsheet application for organizing, analyzing, and sharing large datasets effortlessly.Free and lightweight software that installs quickly and runs smoothly on almost any computer.Familiar, intuitive user interface that requires zero learning curve for users switching from Microsoft Office.
microsoft office alternative - wps office

Frequently Asked Questions

What is a UNC path?

A UNC (Universal Naming Convention) path is a standard format used in Windows to specify the location of resources on a local area network. It is formatted as \\ServerName\SharedFolder\FileName, providing a direct network address rather than relying on a localized mapped drive letter.

Why do mapped drive letters cause issues in shared Access databases?

Different users may map the same shared network folder to different drive letters on their individual computers (for example, one user might map it as X:\ while another maps it as Z:\). If the database hardcodes a specific drive letter, it will fail to locate the linked tables for anyone who doesn't share that exact configuration.

Can I automate the process of linking tables with UNC paths?

Yes, advanced users can utilize VBA (Visual Basic for Applications) code within Microsoft Access to automatically check and refresh linked tables using the designated UNC path upon database startup, which guarantees a seamless experience for all network users.