>I have developed an app in VFP 5.0. A third party wants to read and write to fields in one of my tables (I set aside fields for him to do so). However, his application is a 16 bit app, and he claims his ODBC drivers will not work. Any ideas ????
>
If your stuff is part of a .DBC, or includes any of the new data types, or has even been modified in structure under VFP, he may well not be able to read the file with a DBASE or pre-VFP FoxPro driver; I don't know if there's a 16-bit VFP 3 compatible driver, but am pretty certain that there is no 16-bit VFP 5 compatible driver.
The easiest solution is to make the tables free tables, and to convert them to older-style headers by using COPY TO...TYPE FOX2X to convert the headers, assuming that no new data types are in use (things like Integer, Currency, Date/Time fields can't be in any of these tables, since they aren't supported prior to VFP.) VFP can manipulate the free tables, but you need to be careful not to do anything that will alter the table structure from VFP, or the free tables will not be readable with the older drivers.