Can Microsoft Access Co-Author a Database Through Box?
Question details
The user wants to know whether multiple people can co-author a Microsoft Access database through Box.

- Product
- Microsoft Access and Box
- Device & OS
- not provided
- Scenario
- Multiple users need to work with the same Access database and are considering Box for sharing.
- Observed behavior
- Access does not support simultaneous design co-authoring through Box like an Excel document, and synced database files can produce conflicting copies.
Identify whether users need shared data entry or simultaneous database design changes. For shared data entry, check that all users can reach a shared folder on a reliable wired local network and have permission to create, edit, and delete files there.
Split the Access database for shared data entry
Use separate front-end files and a shared back-end database when multiple users need to enter or edit records on a local network.
Splitting separates tables into a back-end file and leaves forms, queries, and other interface objects in a front-end file. It supports shared data entry, not simultaneous design co-authoring.
Avoid using a Box-synced folder as the shared back end: file synchronization can create conflicting copies rather than coordinate live database access.
Open the Access database you want to share and make sure other users have closed it before you split it.
In Access, select Database Tools > Access Database, then choose Split Database. Follow the prompts to create the back-end file.
Save or move the back-end file to a shared folder on a reliable wired local network. Confirm that each user has the necessary folder permissions.
In the front-end database, open External Data > Linked Table Manager and update the links if needed so they point to the shared back-end file.
Copy the front-end file to each user's computer. Have each user open their own copy and test access to the shared tables.

Use WPS Office for compatible documents and spreadsheets
WPS Office is a free, lightweight alternative with a familiar interface and support for common Microsoft Office formats, making it easier to move document and spreadsheet work between suites. It does not provide Microsoft Access database co-authoring or replace Access.

Frequently Asked Questions
Can several people edit Access records at the same time?
Yes, Access can support shared data entry when users have separate front-end files linked to a shared back-end database. Use a reliable local network and appropriate folder permissions.
Can Box sync an Access database without conflicts?
Box sync does not coordinate live Access database editing. Multiple users working on synced copies can create conflicting files, so use a shared network back end for local multiuser access instead.
Does splitting a database let users co-author its design?
No. Splitting supports shared access to data, but users should coordinate design changes to forms, queries, and other objects and distribute updated front-end copies.
Can Microsoft 365 co-author an Access database like an Excel workbook?
No. Access databases do not support the same document co-authoring feature as Excel workbooks. For shared data entry, use the Access Database Splitter and separate front-end files.




