Is there a way to specify the index file to be used when accessing a VFP free table via ODBC? We use a non-structural .CDX for maintenance and support purposes and this works well for us. (For example, table MyTable.dbf has an index file named MyTableI.cdx.) Some customers would like to update our tables via ODBC; this is done in a controlled manner so we're fine with it. However, since we don't use structural .CDX files, the .CDX files we use aren't opened automatically with the table and therefore aren't updated as updates/inserts/deletes are made via ODBC. The indexes then need to be rebuilt within our application. It would be nice if we could get our .CDX file opened during the ODBC updates and the problem would be solved.

If there is no way to specify the index file directly in ODBC (our first choice), is it possible to send a "SET INDEX TO MyTableI.cdx" command via an ODBC execute command after the table has been opened but before any updates are sent?

TIA,
Twila Miller