I posted similar question before.
I have tried everything, but I have come to conclusion that JET 4.0 and
ADODC does not support indexes.
I even ran Support() function to see if any cursor type would support
indexes, and it came up negative.
Would anybody else confirm this?

tx.
Sok