Hello,
 

We want to update records in a dBase III DBF file that has associated NDX 
indices. Does anyone there know how this can be accomplised?

 

We are currently accessing the DBF files using ADODB and a connection 
string to re\d the files successfully:

 

   DRIVER=Microsoft FoxPro VFP Driver (*.dbf); UID=; Deleted=No; Null=Yes; 
Collate=Machine; BackgroundFetch=Yes; Exclusive=No; 
SourceType=DBF;SourceDB=path

 

But when we update every field in every row of the DBF, the associated NDX 
file is not modified at all - which is NOT good at all!  Is there some way 
to specify the NDX index files in the connection string?

 

I have read about creating an .INF file to specify the NDX index files, 
but surely there is another way to do this. Are there any dBase III 
components for Visual Basic that would handle this?

 

Any advice appreciated,

 

-Steve