Updating DBF with NDX from Visual Basic
Posted on 2003-03-10
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 read 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,