FoxPro automatically reindex

[christak]

I have a very old FoxPro database that I did not design that is in full use where I work. We are using MS access as our front end for this database. Is there a way to have MS Access keep the FoxPro version's Index
up-to-date?

 

[TamarGranor]

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