I am working on a VB project that requires access to multiple DBF files (actually, they are databases created in Clipper using a CDX index and FPT memo file). What is the best way to access files like this in VB? (I currently just need to read the data files, but later may need to update them also... because of their unique index structure, I've found this may be a problem)
I've considered creating ODBC connections, but this seems unfeasible to me since I am access dbf files across multiple directories -- each directory containing the databases for a single client -- and the program will need to access, for example, order.dbf, from any of these directories, and the program needs to be flexible enough to allow the user to select which client to use as the data source. Since I have no way of knowing in advance all the different client directories, I don't see ODBC as a good option.
Does anyone know of any good ActiveX controls or VB classes for manipulating dbf files?
Also, as a side question, does anyone have any idea how to properly use a file like this in Access? In order to work with it, I've had to attach it as a FoxPro file (thus, I'm limited to Access 97 since Access 2000 no longer contains a link/import option for FoxPro!), but because of the CDX index, any changes I make to the file through Access corrupt the index.
I've considered creating ODBC connections, but this seems unfeasible to me since I am access dbf files across multiple directories -- each directory containing the databases for a single client -- and the program will need to access, for example, order.dbf, from any of these directories, and the program needs to be flexible enough to allow the user to select which client to use as the data source. Since I have no way of knowing in advance all the different client directories, I don't see ODBC as a good option.
Does anyone know of any good ActiveX controls or VB classes for manipulating dbf files?
Also, as a side question, does anyone have any idea how to properly use a file like this in Access? In order to work with it, I've had to attach it as a FoxPro file (thus, I'm limited to Access 97 since Access 2000 no longer contains a link/import option for FoxPro!), but because of the CDX index, any changes I make to the file through Access corrupt the index.
