>We may be converting a Clipper program to VFP 7. Problem is we have to read/write live Clipper tables during development. There are about 12 modules accessing the data and the customer wants on module at a time converted.
>
>We have heard that there is an ODBC driver. Has anyone actually done successfully what is described above?
Yes VFP can read/write to the DBFs; however, I think you will have trouble with updating any index files associated with the tables even using ODBC.
Personally, I would not deploy until all modules are ready. If you were dealing with FP tables with CDXs, then I think you would be OK. Clipper NTX files are not structural and therefore not updated unless explicitly open when the table is updated. It has been so long, I think I am remembering this correctly.
However, if these tables are not shared between modules or at least not updated by other modules [i.e., only updated by 1 module and read-only in all other modules], then there should be no problem.
Mark McCasland
Midlothian, TX USA