更新期间MS Access的字段过多 [英] MS Access Too Many fields during UPDATE

问题描述

当我尝试更新MS Access中的表时，它给出了错误消息，提示定义了太多字段.我在Google上搜索，发现我需要修理并压缩，但是仍然无法正常工作?

When I try to UPDATE a table in MS Access, it gives and error saying too many fields defined. I googled and saw that i need to Repair and Compact, which I did, but still does not work?

有人有什么想法吗?另外，什么实际上算作太多字段"计数器?

Anyone has any ideas? Also, what actually count towards the "too many field" counter?

谢谢.

推荐答案

我似乎找到了答案:

Microsoft Jet数据库引擎具有 内部限制为255个字段 询问.作为Microsoft Jet数据库 引擎遍历中的记录 更新查询，它创建一个字段 为原始值和一个字段 更新后的值.超过127时 字段被选中，它到达 查询的255个字段限制.

The Microsoft Jet database engine has an internal limit of 255 fields per query. As the Microsoft Jet database engine iterates through the records in an update query, it creates a field for the original value and a field for the updated value. When more than 127 fields are selected, it reaches the 255 field limit of a query.

请考虑以下SQL 更新查询:UPDATE Table SET A = B， C = D内部查询看起来像 如下:从表中选择A，B，C，D

Consider the following SQL for an update query: UPDATE Table SET A=B, C=D Internally the query looks as follows: SELECT A,B,C,D FROM Table

- http://support.microsoft.com/kb/199​​076

您有〜140个字段，不是吗?

You have ~140 fields, do you not?

这篇关于更新期间MS Access的字段过多的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！