Others

How to Create a Web-Based Microsoft Access Database for Multiple Users

Nimra MalikNimra Malik Nov 2, 2026 872 views

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.

How to Create a Web-Based Microsoft Access Database for Multiple Users
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.
Before you start

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.

Solution 1Recommended

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.

1
Open your Access database

Launch Microsoft Access 2016 and open the database you wish to share.

2
Navigate to the Export options

Click on the 'External Data' tab located on the top ribbon.

3
Select SharePoint List

In the Export group, click on 'More' and select 'SharePoint List' from the drop-down menu.

4
Enter SharePoint site details

Type in your target SharePoint site URL and follow the Export Wizard prompts to migrate your tables to the server.

Deploy Access Tables to SharePoint Lists
Important Limitation: This method only hosts the data tables. Users will still need a local Access front-end connected to the SharePoint lists to use the original forms and reports.
Free Microsoft Office alternative

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. 1. Download the installer: Visit the official WPS Office website and click the free download button for your operating system.
  2. 2. Install the software: Run the downloaded installer and follow the quick on-screen instructions to set up the suite.
  3. 3. Start creating and sharing: Open WPS Office to instantly view, edit, and collaborate on your documents, spreadsheets, and presentations.
Fully compatible with Microsoft Word, Excel, and PowerPoint file formats.Lightweight installation that runs smoothly on Windows, Mac, Linux, and mobile devices.Built-in cloud storage options to easily collaborate on documents with remote users.Includes a powerful integrated PDF editor at no extra cost.
microsoft office alternative - wps office

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.