title: How to do MS Access database paging + search?
body: <p>I have a MS Access 2003 database with a table called <code>product1</code> with a Primary key named <code>Product Code</code>. There is no auto id column.</p>
  
  <p>I have used this sql to do the custom data paging.</p>
  
  <pre><code> SELECT *
  FROM (
    SELECT Top 1  -- = PageSize
    *
    FROM
    (
     SELECT TOP 1  -- = StartPos + PageSize
     *
     FROM product1
     ORDER BY product1.[Product Code]
    ) AS sub1
    ORDER BY sub1.[Product Code] DESC
   ) AS clients
  ORDER BY [Product Code]
  </code></pre>
  
  <p>Now my problem is Search. When I search for something on the database table and point it. </p>
  
  <p>How can I make sure still paging works fine?</p>