I m using MS Access 2003 and using the upsizing wizard i have migrated my database to SQL server 2000. Every time I use the MS Access's default search to search the recordsets of my database for a particular value on a large (10.000 recs) table, the search facility becomes very slow. I have created an SQL trace to see what the problem is and I have found that there is a substantial overhead that has been created on the SQL server when performing the search. My Trace produced 2691 records of transactions for this single search for a field. The search also uses a lot of bandwidth. Any help how to overcome this plese?