VFP keeps indexes in the structural index file (x.CDX, where x is the name of the table) up-to-date automatically. However, other indexes are updated only if they're open at the time the data changes.
The easiest way to keep indexes up-to-date is to ensure that you use only a structural index file. If you're accessing the FoxPro data only from Access and not using existing FoxPro code, you can change the tables to use only structural indexes. If existing code needs to work with the data as well, making such a change could break things.
Tamar