CODEWITHSUNDEEP
databasems-accessvb6adorecordset
User1162527
User1162527

Reputation: 197

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

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.

Upvotes: 1

Views: 285

Answers (1)

HansUp
HansUp

Reputation: 97131

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.

Upvotes: 2

Related Questions