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屋!