Foxpro updates and ODBC

[wmccann]

Hi,

I have a linked Foxpro 2.0 table (part of a commercial payroll program) in my access database using your ODBC connector - everything is great until I go to update a record.

System throws me an error but the odd part is that the error is due a different dbf file (in the same directory). I have not linked to this file. If I remove the file I can update the record as required.

Further investigation lead to the discovery that in the DBF file there is a text field of 255 characters but I believe the actual data in the field is longer than this. I cannot update the field as I get an error.

The exact error when I try to write to any table or open the "bad" table is:

"Field "xxx" of type 'C' has a wrong size 255 (c:...... path and name of table) (#239279088)"

If I change the offending table's suffix to .dbfx I can write to any of the other tables!

Any thoughts on how to resolve/why the odbc driver is accessing tables that are not linked to the access database?

Thanks,

W.