title: Sql server vs MS Access performance
body: <p>I have an existing application which uses Sql Server 2005 as a back-end. It contains huge records, I need to join tables which contain 50K-70K. Client m/c is a lower hardware.</p>
  
  <p>So, can I improve its performance by using MS Access as a back-end? I also need to search operation on an Access file. So, which one is better for performance?</p>
  
  <p>Querying Access is better than querying SQL in lower h/w?</p>