How to change user in linked Sharepoint list

Question

I have a linked SharePoint list in a Access being shared among a team of users. In some of my initial testing at different workstations, I logged in to SharePoint using my credentials on the user's Windows account. Now those credentials are remembered and whenever the user opens the Access app it connects to SharePoint using the saved credentials. I've found no way to "log out" (going into internet explorer/chrome/edge and logging out doesn't help).

Is there a way to force Access to change the saved SharePoint credentials? Ideally I can just put a button using VBA called log out/change user or something like that, but a manual solution is acceptable as well.

Thanks in advance

Answer 1

How is your SharePoint user authentication set up? At our place of work, any connections to SP using Access gets prompted for login credentials.