Hiya.

> 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 ...

Sorry, the 2nd index didn't help, but I've discovered something bizarre! If
I do the search as "Start of Field" it's slow but with "Whole Field" it's
instantaneous. I've confused now.

Regards,

Rob Davis