Hi,

Ann W. Harrison wrote:

> For reasons I don't quite understand, Access is asking for
> the whole table and doing the filtering locally, unless you
> specify FILTER or WHOLE FIELD.
>
>

My FDB uses win1252 collation so I can have lower case searches on
various varchar fields. They all work superbly except for the primary
key. Why is that? I can get round the problem but I don't understand.
Based on the above I would have thought I'd be getting grief on all fields.

Regards,

Rob Davis