I've linked a FoxPro 2.5 .dbf table in Access 2000 Prof using ODBC. I specified a unique identifier in the table so it would be updateable, but every time I try to update a field in the Access table, I get the following error message:
"ODBC -- update on a linked table failed
[Microsoft][ODBC Visual FoxPro Driver]SQL: Statement too long. (#812)"
I looked this error up on the MS knowledge Base, and they basically say to simplify your SQL statement, but I'm just trying to change some records in the table itself without running any queries, so there is no SQL involved on my end.
I have linked other FoxPro tables to the same database using ODBC, and I can update them just fine.
This table is the largest table out of all of them , though(108 fields) - could this be causing the error?
I'm not sure how to go about solving this, and I would appreciate any help.
Thanks!
"ODBC -- update on a linked table failed
[Microsoft][ODBC Visual FoxPro Driver]SQL: Statement too long. (#812)"
I looked this error up on the MS knowledge Base, and they basically say to simplify your SQL statement, but I'm just trying to change some records in the table itself without running any queries, so there is no SQL involved on my end.
I have linked other FoxPro tables to the same database using ODBC, and I can update them just fine.
This table is the largest table out of all of them , though(108 fields) - could this be causing the error?
I'm not sure how to go about solving this, and I would appreciate any help.
Thanks!