Results 1 to 6 of 6
  1. #1
    Join Date
    Apr 2004
    Posts
    4

    Unanswered: Update error: Too many fields

    When I'm trying to update a record with my asp page on my Access database im getting the "too many fields error". The table has 180 columns, can anybody help? INSERT and DELETE works fine!

  2. #2
    Join Date
    Jul 2003
    Location
    SoCal
    Posts
    721
    Can you post your Update statement, or so come code we can look at?

    On a side note, 180 columns is WAY to many for a single table.. you need to normalize that thing. I wouldn't do 180 columns in ANY DB let alone Access...
    That which does not kill me postpones the inevitable.

  3. #3
    Join Date
    Apr 2004
    Posts
    4

    My code...

    Thanks for the interest Seppuku! It's true that I have to normalize my db...
    The txt attachment is my code so maybe you can have a look and help me
    althought the 180 columns!
    Attached Files Attached Files

  4. #4
    Join Date
    Jul 2003
    Location
    SoCal
    Posts
    721
    Wow, you're updating every single column in a single update?

    My initial thought is that updating 180 columns in a single update is out of the range of the DB driver. If you're set on this table having 180 columns, you may want to try to break it into several smaller updates inside of a transaction.
    That which does not kill me postpones the inevitable.

  5. #5
    Join Date
    Apr 2004
    Posts
    4

    Worked!

    Thanks Seppuku!
    I've broken the single 180 columns update into 18 smaller updates and it worked.

  6. #6
    Join Date
    Jul 2003
    Location
    SoCal
    Posts
    721
    Make sure you wrap all of your updates within a single transaction. If one of those updates fails, you'll want to rollback the entire transaction, otherwise some of your data will be updated, some will not, and you'll have a hell of a time cleaning up (especially with 180 columns)
    That which does not kill me postpones the inevitable.

Posting Permissions

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