It is taking forever for my application to search and retreive data ever since I migrated my Access database to SQL Server 7.0. I did not have this problem with Access. I converted my dynamic queries to stored procedures. The problem only got worse. Am I missing something? Thanks for help, Charles