Simultaneous access to a Microsoft Database that is stored in OneDrive

Jody Woodruff 1 Reputation point
2021-12-11T23:33:36.11+00:00

I have 5 users who need access to enter data into a Microsoft database. Only one of the users need to be able to modify the design of the database or objects within the database.
The database file is being shared with each user via OneDrive.

Microsoft 365 and Office | Access | Development
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Ken Sheridan 2,851 Reputation points
    2021-12-13T11:23:34.34+00:00

    OneDrive cannot be used as the location for an Access back end file in this way. When you open a stored file in OneDrive the file is downloaded onto your local machine, and then uploaded again when you have edited the file. Consequently concurrent updates by multiple users of Access front ends are not possible.

    To use Access in this way you would need to use a different technology, such as hosting an SQL Server back end in Microsoft Azure. For more details seethe following link:

    https://www.fmsinc.com/microsoftaccess/cloud/link-to-azure-sql-database.html

    Another possible approach is for each user to remotely access a single PC on which the Access database is installed.

    0 comments No comments

  2. DBG 2,456 Reputation points Volunteer Moderator
    2021-12-13T22:40:09.793+00:00

    Are all 5 users not on the same local network connection?

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.