I have an application in VS (vb) with a database in Access 2007. In the application I have some search functions. They were running very slow until recently when I played around with access andthe indexes. I found that made great improvement in speed. But as the application is running the speed of the searc function diminishes. Any reasons why?? Any help how to improve speed of the search function and make my database provide faster results. Thanks for all your help.