More than 40 fields in ADO Query is too Complex

[Darkbob]

ConString$ is totally wrong

Thanks for the help with the connection string. I'm sure it was wrong and it's nice to have it done properly. Sadly the end result is the same.

Once the database is open, any attempt to use the .update function on the record set generates a "Query too complex" error because I have too many fields.

Editing other tables in the same database works fine so I know things are open properly.

This seems to be just a fundamental limit of ADO.

This program is designed to emulate an old paper form of some type. There are 10 rows. Each row has 9 fields plus a few extras up top for name and date, etc. I thought it was about 60 fields but the entire record has almost 100 fields. Maybe even more. Uggg. It would be more sensible to break the record up into smaller segments and link them together. But that's a lot of coding. *sigh* Time to get typing.