>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.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com