title: Execute SQL Stored procedure using MS Access
body: <p>I need to execute a stored procedure in MS Access 2013. I use Access as front end interface which is connected to two databases. One database has a few stored procedures. I need to execute those with push of button in the Access.</p>
  
  <p>Database is connected through SQL Server authentication. I started a button in Access and here is the VBA code behind this button. It's empty and just simply need more code to get it running:</p>
  
  <pre><code>Private Sub UpdateItems_Click()     
  End Sub
  </code></pre>
  
  <p>Here are the parameters to establish the connection and stored procedure name:</p>
  
  <p>Server Name: <strong>BOX\SQL2014</strong> <br>
  User Name: <strong>sa</strong> <br>
  Password: <strong>123456PS</strong> <br>
  Database: <strong>SixBit</strong> <br>
  Stored procedure name: <strong>spRefreshItems</strong></p>
  
  <p>Please don't refer me to similar question. I don't work with VBA Code and i wasn't able to mimic something from slightly different but similar example. </p>