Who's been around a while?

I've got a system in FoxBase+ that I have to keep intact, but I'm
writing a VFP utility that includes appending data to one of the
tables also used by the foxbase system.

This table has three indexes (standalone old-fashioned IDX files) -
all normal, not unique, not candidate.

However, when I open the table in VFP with the indexes, and add/alter
data, VFP treats the indexes as CANDIDATE indexes and won't let me
enter a duplicate key.

Anyone know a way round this? I need the records I add to be added to
the index, and I can't issue REINDEX because I can't get exclusive
access to the table.

Many thanks
Ben

How about using SQL statements and even local Views to manipulate the dbf ?