MS Access错误:该字段太小，无法接受您尝试添加的数据量 [英] MS Access error: The field is too small to accept the amount of data you attempted to add

问题描述

因此，我试图在MS Access 2007-2010数据库中运行一个聚合查询，该数据库按在2个表中的几个字段中比较的值进行分组.尝试运行查询时，出现错误字段太小，无法接受您尝试添加的数据量"

SELECT * FROM 
orderTable AS a INNER JOIN availableInventory AS b ON (a.sellerID = b.sellerID) AND 
(a.daysofweek = b.daysofweek) AND (a.supplierID = b.supplierID);

当我删除其中一个约束时，不会出现此错误.这是MS Access的限制吗?

表a大约有3000行，表b大约有6000行.

解决方案

是否必须使用select *?看起来您的一个表中有一个memo字段正在返回大量数据.而是尝试像这样列出您选择的字段:

select a.orderID, b.partno, etc.

或者，更改查询以使用 UniqueValues = 否

另请参阅: http://support.microsoft.com/kb/896950

So I'm trying to run an aggregation query in a MS Access 2007-2010 database that groups by values compared across a few fields in 2 tables. When I try to run the query, I get the error "The field is too small to accept the amount of data you attempted to add"

SELECT * FROM 
orderTable AS a INNER JOIN availableInventory AS b ON (a.sellerID = b.sellerID) AND 
(a.daysofweek = b.daysofweek) AND (a.supplierID = b.supplierID);

this error doesn't appear when I remove one of the constraints. Is this a MS Access limitation?

table a has ~3000 rows and table b has ~6000 rows if that's relevant.

解决方案

Do you have to use select *? It looks like one of your tables has a memo field which is returning a large amount of data. Instead try to list the fields of your select like this:

select a.orderID, b.partno, etc.

Or, change your query to use UniqueValues = No

See also: http://support.microsoft.com/kb/896950

这篇关于MS Access错误:该字段太小，无法接受您尝试添加的数据量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！