Excel VBA to query MS Access database on Sharepoint with ADODB - "Not a valid file name"
<p>any chance someone could enlighten me on why I'm getting an "Not a valid file name" error when trying to connect to MS Access database stored on Sharepoint? I have no issues with connecting to file on C:\</p>

<pre><code>    Set cnn = New ADODB.Connection
    MyConn = "C:\somelocation\database.accdb"

    With cnn
        .Provider = "Microsoft.ACE.OLEDB.12.0"
        .Open MyConn
    End With
</code></pre>

<p>but when I change <code>MyConn</code> to Sharepoint address it doesn't work :/</p>

<pre><code>     MyConn = "https://some.website.com/somelocation/database.accdb"
</code></pre>

<p>I'm getting a "Not a valid file name".
I'd greatly appreciate your help!</p>