Robin Davis wrote:

>
> Nope, no second index.
>
> Ergo, a problem with the
> search fucntion in Access I suppose. Strange, if I FILTER for the
> record, the result is as quick as iSQL.

You might try defining the second index. It's possible that
Access is looking for a user defined index and not recognizing
the system index as useful. Unlikely, but ...

Regards,


Ann