Query too complex - ADO : URGENT !!!

[Girish Chandra]

Hi everybody,

I use ADO for all my database access through VB. Recently while making a database entry form I had a table with 50 fields. While adding new record everything works fine, but when I modify an existing record I get an error "Query too complex". By trial and error I found that if I modify upto 39 fields the update was proper but any higher and I get this error message. Can anybody tell me a way out.

Please treat this as URGENT, my project is held up for this.
Thanks
Girish Chandra

[Lothar Haensler]

msdn article Q192716 describes the problem and a few workarounds.
the only one that is a true workaround IMHO is: use DAO instead of ADO.