MS Access + SharePoint - Simultaneous access from multiple PCs. Multiple licenses needed?

Question

I have taken out a SharePoint "Plan 1" subscription to offload the BackEnd of my local MS Access database.

In order to allow other users to access the SharePoint tables via the Access client, all users must be logged into the Access desktop client with an authorized account to authenticate the users.

But now I don't know how to create multiple accounts to assign them to the users for the respective PCs.

As far as I know, I only have one account (username AT company.microsoft.com), which I set up when I purchased the SharePoint subscription. How do I create additional accounts?

Example: The database should be accessible from 3 different PCs at the same time. On all PCs the Access-FrontEnd/Client is on it, which should be linked with the outsourced tables in SharePoint, so that all 3 users can work with it.

In order for the FrontEnd/Client on each PC to connect to SharePoint, they all have to log in to the Access client to get access to the SharePoint BackEnd.

So, in my opinion, you have to create a total of 3 accounts to register them as members and use them to log into the Access clients to get access and work with the MS Access database. One account is automatically added as a member or admin when creating a SharePoint site (username AT company.microsoft.com). So there are 2 accounts missing for the 2 remaining PCs. How to add members I already figured out, but how to generate the accounts now is still unclear to me!

I would be very happy for a solution to this problem. Thanks a lot!

Answer 1

Dear Dev0p,

Good day! Thank you for posting to Microsoft Community. We are happy to help you

Based on your description, we understand that you want users to be able to access SharePoint through Access, and that you have purchased a subscription to SharePoint.

Business accounts are typically created in the Administrator Center, Add users and assign licenses in Microsoft 365 - Microsoft 365 admin | Microsoft Learn

In your case, I don't think you need to create additional accounts, if the user has an account themselves, you can invite the user directly and thus assign them access to SharePoint. Ref:Share a list or list item - Microsoft Support

We look forward to your reply. Thanks for your cooperation.

Sincerely,

Tin | Microsoft Community Moderator