Redirect Microsoft Access Linked Tables Across Multiple Computers
Question details
Use Access linked tables on multiple computers when synchronized CSV files have different local paths.

- 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.
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.
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.
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.
Open Database Tools > Access Database and follow the Database Splitter wizard to create a back-end database containing the local tables.
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.
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.

Relink CSV files from a consistent network path
Use this option when the data must remain in CSV format and every computer can reach the same network share.
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.

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.




