File Sharing Problems

Use a Microsoft Access Backend Database Remotely with Microsoft 365

Camila MilosovichCamila Milosovich Nov 20, 2026 869 views

Question details

The user needs a safer way to access an Access backend database while working remotely.

Use a Microsoft Access Backend Database Remotely with Microsoft 365
Product
Microsoft Access for Microsoft 365
Device & OS
not provided
Scenario
A user wants to work with a split Access database away from the location of its backend file.
Observed behavior
Opening an Access backend over an unreliable Internet connection can cause poor performance and database corruption.
Before you start

Identify the backend file, its linked front end, and everyone who uses the database. Decide whether only one person will edit the data at a time or whether multiple users need simultaneous access.

Solution 1Recommended

Transfer a Local Backend Copy for Occasional Single-User Access

Use this approach when one person needs the database remotely and no one else will edit it until the updated copy is returned.

1
Stop other edits

Ask all users to close the Access database and agree not to use or modify another backend copy during the remote session.

2
Upload the backend

Close Access, then use OneDrive to upload the current backend file. Wait for the upload to finish.

3
Download and relink

On the remote computer, download the backend to a local folder and open the Access front end. If necessary, use External Data > Linked Table Manager to relink the tables to the downloaded backend.

4
Return the updated file

When finished, close Access and upload the updated backend to OneDrive. Replace the authoritative copy with the updated file before allowing anyone else to use it.

Transfer a Local Backend Copy for Occasional Single-User Access
Avoid conflicting copies: Do not open the backend directly from OneDrive or let multiple users edit separate copies. OneDrive file synchronization does not merge Access database changes.
Free Microsoft Office alternative

Use WPS Office for Documents and Spreadsheets on the Go

WPS Office is a free, lightweight alternative for working with familiar Office documents and spreadsheets. Its familiar interface and support for common Microsoft Office formats make it easy to move everyday files between suites. It does not replace the Access database engine or fix remote Access backend connections.

Work with spreadsheets for tabular tasks that do not require an Access database.Open and edit common Microsoft Office formats, including DOCX and XLSX.Use a familiar interface for everyday documents and spreadsheets.Move common Office files between applications with minimal disruption.
microsoft office alternative - wps office

Frequently Asked Questions

Can I open an Access backend directly from OneDrive?

Avoid opening the backend directly from OneDrive or a synced folder for shared use. For occasional single-user work, download a local copy, use it while all other users are stopped, and upload the updated file when finished.

How do I connect my Access front end to a downloaded backend?

Open the front end in Access and use External Data > Linked Table Manager to update the table links to the backend file in your local folder.

What should I use if several people need remote access at once?

Consider moving the shared tables to SQL Server or SharePoint and linking them to the Access front end. Test compatibility, permissions, and remote connectivity before moving everyone to the new data source.

Does WPS Office replace a Microsoft Access database?

No. WPS Office can handle common document and spreadsheet tasks, but it does not replace the Access database engine or resolve Access backend connectivity problems.