Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Posts
    1

    Unanswered: Large tables linked to FoxPro

    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?

  2. #2
    Join Date
    Jan 2004
    Location
    The Netherlands
    Posts
    421
    Try using Select * from....

    Greetz

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •