File Sharing Problems

Open a Microsoft Access Database in Shared Mode on a Network

Olivia MillerOlivia Miller Nov 20, 2026 869 views

Question details

The user needs multiple people to open an Access database on a shared network, including a database with linked SharePoint lists.

How to Open a Microsoft Access Database in Shared Mode on a Network
Product
Microsoft Access
Device & OS
not provided
Scenario
Multiple users need to work with an Access database stored in a shared network location.
Observed behavior
The database opens in exclusive mode, and splitting it did not resolve the multiuser access issue. The database also contains links to SharePoint lists.
Before you start

Identify the shared network folder, the database back end, and any linked SharePoint lists. Ask all users to close the database before changing its structure or investigating a remaining lock file.

Solution 1Recommended

Check shared opening settings and network folder permissions

Use this first when Access opens the database exclusively or other users cannot open it at the same time.

1
Set the default open mode

In Access, open File > Options > Client Settings. Under Advanced, set Default open mode to Shared, then select OK. Check this setting on each user's Access installation.

2
Open without exclusive mode

Select File > Open > Browse, choose the database, and select Open. Do not choose Open Exclusive from the arrow next to the Open button.

3
Check folder permissions

Ask the network administrator to verify that every user has read, write, create, and delete permissions in the shared folder containing the database back end. Access needs to create and update a lock file there.

4
Test simultaneous access

Have two users open the database from their own computers and test access at the same time. If the problem remains, record the exact error message and continue with the split-database and SharePoint checks.

Check shared opening settings and network folder permissions
Check for a remaining lock file: An .laccdb or .ldb lock file can remain after an abnormal shutdown. Confirm that everyone has closed the database before investigating it; do not delete an active lock file.
Free Microsoft Office alternative

Use WPS Office for Compatible Spreadsheets and Documents

WPS Office is a free, lightweight alternative with a familiar interface for working with Office files. It can help you migrate spreadsheet and document work, but it does not replace Access or fix Access shared-mode and SharePoint-linked database issues.

Work with spreadsheet data exported from Access when a database application is not requiredOpen and edit Microsoft Excel XLSX and Word DOCX filesUse a familiar Office-style interfaceMove supported documents and spreadsheets into a lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Where do I change the default open mode in Access?

Go to File > Options > Client Settings and find Default open mode under Advanced. Select Shared and repeat the check on each user's Access installation.

Why does Access need write access to the network folder?

Access creates and updates a lock file in the database folder to manage shared use. Users need appropriate read, write, create, and delete permissions on the folder containing the back end.

Should everyone use the same front-end file?

For a split database, give each user a separate local front-end copy and link its tables to the shared back end. Use External Data > Linked Table Manager to check the links.

Do I have to remove SharePoint links to enable shared access?

Not necessarily. First check each user's SharePoint list access and review the links in External Data > Linked Table Manager. The exact error and application configuration determine the next troubleshooting step.

Can WPS Office open and run my Access database?

WPS Office is not a replacement for an Access database application. It can work with supported files such as Excel spreadsheets, including data exported from Access, but it does not run Access forms or resolve database locking.