Others

Redirect Microsoft Access Linked Tables Across Multiple Computers

Adam DavisAdam Davis Nov 20, 2026 868 views

Question details

Use Access linked tables on multiple computers when synchronized CSV files have different local paths.

Redirect Microsoft Access Linked Tables Across Multiple Computers
Product
Microsoft Access
Device & OS
not provided
Scenario
An Access database links to CSV files stored in Dropbox or another synchronized folder on multiple computers.
Observed behavior
Linked tables can break because the local path to the synchronized files differs between computers.
Before you start

Confirm that each computer can access the intended shared folder and that users have the necessary read or write permissions. Decide whether the data must remain in CSV files or can be imported into an Access back-end database.

Solution 1Recommended

Split the Access database and link to a shared back end

Use this approach when the data can be stored in Access tables and multiple computers need a consistent shared location.

A split database keeps tables in a back end on a reliable network share and forms, queries, reports, and code in a separate local front end on each computer. If the source data currently exists only in linked CSV files, import it into Access tables before splitting; splitting alone does not convert linked CSV files.

1
Import CSV data if needed

In Access, open the database and use External Data > New Data Source > From File > Text File to import each CSV into a new local table. Verify the imported fields and data.

2
Split the database

Open Database Tools > Access Database and follow the Database Splitter wizard to create a back-end database containing the local tables.

3
Place the back end on a share

Move the back-end file to a reliable network share accessible to every computer, such as \\machinename\folder\database.accdb. Grant users the permissions needed to access the file and folder.

4
Relink and distribute the front end

In the front end, open External Data > Linked Table Manager, select the back-end tables, and relink them using the shared UNC path. Place a separate copy of the updated front end on each computer and test the links.

Split the Access database and link to a shared back end
Avoid synchronized back ends: Do not use Dropbox or OneDrive synchronization as a substitute for a shared Access back end: synchronization conflicts can create competing copies. Distribute updated front-end copies when the application changes.
Free Microsoft Office alternative

Work with CSV files in WPS Spreadsheets

WPS Office is a free, lightweight alternative for everyday spreadsheet and document work. Its familiar interface and Microsoft Office format compatibility make it easy to move existing files. WPS does not repair Access linked tables or replace an Access database.

Open and review CSV data in WPS SpreadsheetsCompatible with Microsoft Excel formats such as XLSX and XLSFamiliar spreadsheet interface for everyday editingFree, lightweight suite for documents and spreadsheets
microsoft office alternative - wps office

Frequently Asked Questions

Why do my Access CSV links work on one computer but not another?

The link may contain a local Dropbox or synchronized-folder path that differs on the other computer. Use External Data > Linked Table Manager to inspect and update the link, or recreate it using a shared UNC path.

Can I keep the data in CSV files instead of splitting the database?

Yes. Put the CSV files on a network share that every computer can access, then relink them through External Data > Linked Table Manager or recreate the links using External Data > New Data Source > From File > Text File.

Would OneDrive be better than Dropbox for the Access back end?

Neither synchronized folder is a reliable substitute for a shared Access back end. Synchronization can produce conflicting copies; use a reliable network share and a consistent UNC path instead.

How do I distribute changes to a split Access database?

Develop and test the front end, then distribute an updated local front-end copy to each computer. Keep the shared tables in the back end and verify the links in External Data > Linked Table Manager.