I'm double posting here in hopes to get a fast answer...pls forgive.

We have 2 identical queries. We run it in the BDE and it works fine.

We run it in ADS Data Arch and it crashes with a 7038 error msg. This
relates to the index being bad.

If we reindex or remove the index from the dbf (using a hex editor) it works
fine. (the file format is Foxpro 2.6). However, this is not an option in
production.

Is there anyway that I can tell the ADS engine not to use the index on the
file. I'm assuming that it uses it when it does the "WHERE" portion of the
query. Any suggestions would be appreciated.

Tks.