>I don't know how to open Index files with ODBC...
Using structural indexes will eliminate such problem.
From VFP help:
The structural indexes:
Opens automatically when you open a table.
Can contain multiple ordering scenarios, or index keys, in the same index file.
Is automatically maintained as you add, change, or delete table records.
--sb--