How to Create a Web-Based Microsoft Access Database for Multiple Users
Question details
Users need to allow multiple people in different locations to sign in, view, and edit a Microsoft Access database concurrently in real time.

- Product
- Microsoft Access 2016
- Device & OS
- not provided
- Scenario
- An organization wants to transition a local Access database to a web-based or cloud-hosted environment for remote multi-user collaboration.
- Observed behavior
- The user is seeking the best deployment options, such as using SharePoint lists, custom web applications, or a hosted database back-end, to achieve real-time web access.
Ensure you have full administrative rights to your Microsoft Access database and create a complete backup of the .accdb file before attempting to split or migrate the data.
Deploy Access Tables to SharePoint Lists
Use SharePoint to host your Access tables, providing a low-cost, integrated back-end that allows multiple users to connect simultaneously.
SharePoint is an effective solution if implemented correctly within the Microsoft ecosystem. You can deploy Access tables as SharePoint lists to serve as the back end for your data.
Keep in mind that while tables can be migrated, Access forms and reports cannot simply be deployed as SharePoint lists. You must review SharePoint's data and feature limitations before choosing this approach to ensure it meets your organization's requirements.
Launch Microsoft Access 2016 and open the database you wish to share.
Click on the 'External Data' tab located on the top ribbon.
In the Export group, click on 'More' and select 'SharePoint List' from the drop-down menu.
Type in your target SharePoint site URL and follow the Export Wizard prompts to migrate your tables to the server.

Build a Custom ASP or PHP Web Application
Create a dynamic web application using ASP or PHP for flexible, browser-based real-time data access.
Looking for a Lightweight Office Suite? Try WPS Office
While WPS Office does not include a database application like Microsoft Access, it is an exceptional, free alternative for your daily word processing, spreadsheet, and presentation needs. It features a highly familiar interface, seamless document sharing, and complete compatibility with standard Office files.
- 1. Download the installer: Visit the official WPS Office website and click the free download button for your operating system.
- 2. Install the software: Run the downloaded installer and follow the quick on-screen instructions to set up the suite.
- 3. Start creating and sharing: Open WPS Office to instantly view, edit, and collaborate on your documents, spreadsheets, and presentations.

Frequently Asked Questions
Can I put my Access database on OneDrive or Dropbox for multiple users?
No, it is highly discouraged. Sharing an active Microsoft Access database file via file-syncing services like OneDrive, Dropbox, or Google Drive can lead to severe file corruption and conflicting copies when multiple users attempt to edit data at the same time.
Can I publish Access forms and reports directly to the web?
In newer versions of Access, Microsoft has retired the Access Web Apps feature. You cannot directly publish forms and reports to the web or SharePoint. You must either use SharePoint lists connected to a local desktop front-end, or recreate the UI using web technologies or Microsoft Power Apps.
What is a split Access database?
Splitting an Access database means dividing it into two separate files: a 'back-end' file containing only the data tables, and a 'front-end' file containing the queries, forms, and reports. The back-end is placed on a shared network or server, while a copy of the front-end is distributed to each user's computer.




