title: How can I update an Access database in SharePoint from Excel?
body: <p>I currently have an Access database stored locally. I update this by using Excel as a front-end to input some information and have VBA that inputs records to the database. That is to say, I have a table in Excel that I can add rows to and run a macro that executes some SQL to put it into Access.</p>
  
  <p>I want multiple people to be able to make changes to the Access database, so I have stored it in SharePoint. The problem is that just changing the filepath in my VBA gives me "Operation must use an updateable query" because opening the database is done in read-only mode when you open from SharePoint.</p>
  
  <p>The VBA looks something like this:</p>
  
  <pre><code>Sub Insert()
      Set appAccess = CreateObject("Access.Application")
      appAccess.OpenCurrentDatabase accDbLocation, True
      theSQL = "insert into Table(data)"
      appAccess.CurrentDb.Execute theSQL
      appAccess.CloseCurrentDatabase
  End Sub
  </code></pre>
  
  <p>Is there any good workaround for this? Perhaps a way to check-out the database from SharePoint, make changes, then check it back in? Failing that, are there other ways to interact with an access db on SharePoint, like making a form that could be used to add records?</p>
  
  <p>Thanks!</p>