Access database for multiple users via SharePoint or OneDrive

Natalie Hamilton
Natalie Hamilton used Ask the Experts™
on
I need a workaround for an Access database. We only have SharePoint and OneDrive as our sharing options and I would like to enable the database to be accessed by multiple users. We don't have the ability to build/ link in Azure or PowerApps. I know SharePoint has discontinued their Access web application, but still allows for the sharing of files, but I would like everyone to be able to access the database and make changes simultaneously. We are encountering an issue where everything is in Excel and one person has to wait until the document is locked until that person is done with it. Which is one of the reasons why I wanted to move to an Access database. Is it possible to split the database, put the back-end on the sharepoint and link the front-end/ share the front-end with multiple users so the tables are updated simultaneously?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Walter CurtisSharePoint AED
Distinguished Expert 2018

Commented:
What version of SharePoint are you using?

Author

Commented:
I'm assuming the latest one since we only have access to the web based platform.
Most Valuable Expert 2015
Distinguished Expert 2018
Commented:
If you can move your tables to SharePoint Lists and link these in your frontend:

SharePointList.PNG
it should be doable.

For the distribution of the frontend, you could use the method described in my article:

Deploy and update a Microsoft Access application with one click
11/26 Forrester Webinar: Savings for Enterprise

How can your organization benefit from savings just by replacing your legacy backup solutions with Acronis' #CyberProtection? Join Forrester's Joe Branca and Ryan Davis from Acronis live as they explain how you can too.

Author

Commented:
I don't have access to run this type of script on my computer. How else would I be able to deploy the front end? Can the forms that I created be imported on SharePoint and used that way?

Also, is there a way to do a bulk upload from access to SharePoint in which includes a multi-select option. The problem is that the form has a email lookup category, which is fine being saved and being brought down to the access linked sheets, but inputting the information from access to be updated in SharePoint for the same multi-select category gives an error. Is there a work around for this?
Most Valuable Expert 2015
Distinguished Expert 2018

Commented:
Not that I know of. Sadly, the combo of Sharepoint and Access is quite limited.

Author

Commented:
Is there an easier way to convert the forms created in Access to SharePoint?
Most Valuable Expert 2015
Distinguished Expert 2018

Commented:
I've never heard of any.
Most people/developers, I believe, create forms etc. either for SharePoint or in Access.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial