
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.