I linked several tables in MS Access to Visual FoxPro tables using a ODBC driver. I can edit most of the tables, but I can't save changes to a couple of the larger ones with a lot of fields. I edit a record and try to save it and get the error
"[Microsoft][ODBC Visual FoxPro Driver]SQL: Statement too long. (#812)"
I figure that the record has too many fields for SQL to handle. I really need to be able to edit these tables with Access. Is there any way to fix or get around this?