Evan,

Is your table on a network drive ?

This could have a huge impact depending on network traffic...

I just tried a simple query on a table with over 1,000,000 records
and it took close to 15 seconds (on the network, with maybe 50 users having
the table opened at the moment) so maybe your 5-7 seconds
is not so bad :)

HTH

Pascal