Search at form very slow

T

Tony WONG

the table is very simple, just 10 fields with 300K records.

However, i find it extremely slow to search at Form recently.

when i search records with "ABC*", the 1st record show up after 90 seconds

if i search in query, all the records show up within 5 seconds

What's wrong? i use Access 2007 sp1

thanks a lot.

tony
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2003 vs 2010 1
Build search function in to a form 5
form loads slow - 7 seconds 4
Alternative to union query 32
A2007 Slow typing 5
txt search box returns all records when wildcard is entered 3
Access2007 slow, what can I do? 9
Conexion to SQL Server Express 2008 very slow 4

Top