Andrew,

I know you've solved your problem, but why does the ODBC access from another application preclude the use of an index? FoxPro takes care of updating indexes automatically.

Unless of course you mean you can't index NOW because there is no easy way to have exclusive use of the table.


>I cannot index either. This table is updated by a separate application that updates the table through ODBC.