Open a Microsoft Access Database in Shared Mode on a Network
Question details
The user needs multiple people to open an Access database on a shared network, including a database with linked SharePoint lists.

- 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.
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.
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.
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.
Select File > Open > Browse, choose the database, and select Open. Do not choose Open Exclusive from the arrow next to the Open button.
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.
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.

Verify the split database and local front-end copies
Use this setup for a multiuser Access database, or check it if a previous split did not solve the problem.
Check SharePoint-linked lists for each Access user
Use this when the split database still fails and the front end includes links to SharePoint lists.
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.

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.




