Retrieve more than 250 fields from two tables in MS-Access

Question

We have two tables which have more than 250 fields. We need to read and update data using one Recordset (ADO) at once and not working with tables separately (in vb 6) but seems that Ms_access has limitation on number of fields (250).

Any suggestion ? Thank you.

Answer 1

The Access limit for Number of fields in a table = 255. That limit also applies to queries. And the same limit is "inherited" by recordsets based on those tables or queries.

You will have to refactor somehow: redesign the tables; split your recordset processing into batches which handle <= 255 fields.