Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Linking problems to VFP 7.0 tables w/ more than 84 fields

Status
Not open for further replies.
sqleptical

sqleptical

Programmer
Sep 26, 2001
112
US
When I link to VFP 7.0 tables that have more than 84 fields from either Access 97 or 2000, and I try to make any changes to the data in the fields of those tables, I get the following error:

ODBC--update on a linked table 'tablename' failed.

When I click OK on the error, I get:

[Microsoft][ODBC Visual FoxPro Driver]SQL: Statement too long.(#812)

I have installed the most up-to-date VFP ODBC driver and have been unable to find any known issues with this on the Web. Does anybody know a work-around for this? Any help would be appreciated.
 
Status
Not open for further replies.

Similar threads

BugZap13
  • Locked
  • Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
542
mikrom
mikrom
TheresAlwaysAWay
  • Locked
  • Question
Union query provides different reslt than when summing the combined queries individually 1
Replies
12
Views
1K
TheresAlwaysAWay
TheresAlwaysAWay
C
  • Question
Query expression negative to a 0
Replies
6
Views
310
dhookom
dhookom
MDGarcia
  • Locked
  • Question
Error Could not delete from specified tables 2
Replies
14
Views
1K
MDGarcia
MDGarcia
btamsgn
  • Locked
  • Question
how to create a crosstab query 1
Replies
1
Views
2K
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top