>>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.
three years ago i used an odbc driver made by a company called 'intersolv' to successfully update clipper indexes during writes inside a VFP program...
I do not believe intersolve exists any longer ... the product is now sold by 'Merant'
check out
http://www.datadirect-technologies.com/odbc/techresources/matrix/connectodbc.htmfor more thorough information on this subject....
i think the product listed at the above URL is identical to what i used from intersolve...
Dave.