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!

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...

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!

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.

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

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)