Query too complex - ADO : URGENT !!!
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
Re: Query too complex - ADO : URGENT !!!
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.