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.Statistics: Posted by wmccann — Fri 14 Oct 2022 02:28
]]>