title: MS Access query from VB6 too long?
body: <p>I perform a query on an Access 2010 DB from a VB6 application. The SQL looks like that:</p>
  
  <pre><code>SELECT *, NetPrice AS Price 
  FROM Products 
  WHERE Len(ProductName)&lt;&gt;0 AND ProductID IN (1,5,8,13);
  </code></pre>
  
  <p>The following Code performs the query:</p>
  
  <pre><code>Set ResultRecordset = myDataBase.OpenRecordset(SqlCode, dbOpenSnapshot)
  </code></pre>
  
  <p>So far, everything is fine, but when the Number of the IDs in the List increses to about 50, then the ResultRecordset is <code>Nothing</code>. I have found some limitations for Access <a href="http://www.databasezone.com/techdocs/acclimit.html" rel="nofollow">here</a>, but I am far below the values provided there (1 Table, 200 characters query length, no nested subqueries,...). Any ideas what's going wrong? </p>