Hi!

In addition to Stephen notes, the explanation of this limitation:
VFP maintains each structural index after changes in the table to update index so it is always corrcet. When you use non-structural indexes, they're not buffered by transaction process, so changes made will not update non-structural indexes. This will cause index corruption, and thus, application crashes.

For whatever reason you used the non-structural indexes, you can workaround this by many ways:
- use structural indexes
- close non-structural indexes before transaction, than reindex
- organize your forms so aliases with non-structural indexes are not in the data session where you perform the transaction..


HTH.


>I am running a program and and it has a begin transaction. When the program hits this, I get the error "one or more structural indexes are open. Please close them and retry the begin transaction. Why do I get this message and why would it care that an index is open.