title: MS Access call SQL Server stored procedure
body: <p>I have an MS Access application that contains all tables linked to SQL Server, so in MS Access VBA code or query I work with those tables very simple, I access them via name, like <code>[Customers]</code>.</p>
  
  <p>Also I have a stored procedure in SQL Server called <code>sp_CopyData</code> which I need to call from my VBA code. How can I do that without creating new connection to SQL Server (I already have it somewhere!? because I have access to tables)?</p>
  
  <p>Or it's impossible? Appreciate any help. Thanks!</p>