title: Is it possible to access an access database inside a query to a SQL server? (using C# and Queries)
body: <p>I'm trying to search in an access database in a query directed to a SQL server. </p>
  
  <pre><code>UPDATE [" + TableVariable + "] 
  SET TK_Date = DATEADD(d,-1,GETDATE()), TK_CA = TK_CA - 1 
  WHERE TK_Date &gt;= GETDATE()
  AND TK_CA &gt; 0 
  AND TK_ResultCode in (SELECT Result_Code FROM [MS Access;DATABASE=C:\Users\Config.mdb].[Result_Code] 
  WHERE Status = 2 
  AND Project_ID = " + ProjectVariable + "
  AND [" + TableVariable + "].TK_CA &lt; [MS Access;DATABASE=C:\Users\Config.mdb].[Result_Code].TK_CA)
  </code></pre>
  
  <p>This is executed from a C# application.
  the error i get is: Invalid object name 'MS Access;DATABASE=C:\Users.Config.mdb.Result_Code'</p>
  
  <p>The variables are being filled in correctly and i have a connection to the databases aswell.</p>
  
  <p>I tried a lot of combinations and searched on google for a couple of hours, but couldn't find anything helpful.</p>