I have been fighting with this error for a couple of days now! I issue a simple query like "SELECT * FROM Clients WHERE (Category ="Garage")" which returns a recordset that is one row by about 90 columns. The data populates about 70 bound text boxes (it's a busy page!) When I issue a recordset.update VB returns a "Query too complex" error.

The help indicates that this is due to too many fields in the SELECT clause. Indeed if I pare down the * to a few explicit field names the .update works swell. (The error occurs somewhere between 16 and 43 fields in the SELECT clause)

Is there really a limit to the number of fields in a SELECT clause? Could it be as low as 43????

BTW I am using VB6, Jet 3.51, and an Access97 db.