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).
我们有两个表，有超过250个字段。我们需要同时使用一个记录集(ADO)读取和更新数据，而不是单独使用表(在vb 6中)，但是Ms_access似乎对字段的数量(250)有限制。
Any suggestion ? Thank you.
任何建议吗?谢谢你！
1 个解决方案
#1
2
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.
表中字段数的访问限制= 255。这个限制也适用于查询。基于这些表或查询的记录集“继承”了相同的限制。
You will have to refactor somehow: redesign the tables; split your recordset processing into batches which handle <= 255 fields.
你将不得不进行重构:重新设计表格;将记录集处理分割为处理<= 255字段的批处理。
#1
2
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.
表中字段数的访问限制= 255。这个限制也适用于查询。基于这些表或查询的记录集“继承”了相同的限制。
You will have to refactor somehow: redesign the tables; split your recordset processing into batches which handle <= 255 fields.
你将不得不进行重构:重新设计表格;将记录集处理分割为处理<= 255字段的批处理。