i am trying to access a vfp database through the microsoft odbc driver version 5.00.00xx.

my application works fine until the I added the 50th field to one of the tables. at that point the driver reported an error 'SQL statement too long'. actually, i can get a few more fields if i shorten the field names. the problem seems to be with the overall length of field names. (it seems that the driver formats a sql string containing all field names even if only one is being updated).

this happens if i access the database with VB and RDO or using Delphi's database explorer. so i am reasonably certain that the problem is with the odbc driver.


question:
is there a better or more recent driver?

is there a better way to access vfp data from a front-end application?


thanks
bill