I'm doing small applications on Access and VB 6. I'm facing some problems regarding performance. Whenever the no. of records are growing morethan 1000 the performance of the application is going down and responding very slowly. My main objective of that application is to support 60,000 records per year. How can I improve my application performance to achieve that objective. And mostly is there any need to go through for database programming concepts. If yes plz. suggest a good book for database programming. plz mail to msrs_it@lycos.com