Share via

Why does VBScript connecting to SharePoint require re-authentication on VM2 but not on VM1?

Anonymous
2025-02-27T13:08:29+00:00

I have two virtual machines (VM1 and VM2). On both VMs, I'm using the same VB script with this connection string to connect to SharePoint: Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=2;RetrieveIds=Yes;DATABASE=http://mysharepointsite.com/documents/;LIST={5999B8A0-0C2F-4D4D-9C5A-D7B146E49698};

On VM1, when I run the script, it connects to Microsoft Access and SharePoint automatically without asking me to log in again.

However, on VM2, when I run the exact same script using the same SharePoint account, Microsoft Access prompts me to log in again.

Why is this happening? What's causing the difference in behavior between the two VMs?

Microsoft 365 and Office | Access | Other | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2025-02-27T13:36:35+00:00

    I'm afraid you've posted in the wrong forum, this forum is for discussing Microsoft Access database related issues. I'd recommend you repost your question in a more appropriate forum to get the help you seek.

    0 comments
  2. Anonymous
    2025-02-27T13:48:44+00:00

    The problem appears to be related to the configuration of the two different VMs. We can't know how you configured them or how you set up the MS accounts on each.

    Perhaps you should compare how the two accounts are set up for each of your VMs, e.g. make sure you are using the proper credentials for both.

    0 comments