>Hello,
>I am getting "Too many fields defined " error when Im saving 240 fields to an access table. Although I followed MS advice to compact the Access Database or to use a ADO recordset update method for saving, I am still getting this error.
>Does anybody know a solution for this issue?
>Thank you,
>Vlad.

Are you using AddNew ? Replace it with a INSERT query.