title: Excel VBA to query MS Access database on Sharepoint with ADODB - "Not a valid file name"
body: <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>