MS Access数据库中的表中可以添加的最大行数是多少 [英] What is the maximum no of rows that can be added in a table on MS Access database

问题描述

大家好，



有人可以告诉我MS访问数据库表的限制是什么。 Bcoz我无法从前端添加更多2048行。它是一个Windows应用程序，其中数据通过接口添加到它。但问题是数据没有超过2047行。我有11列数据类型MEMO。当它在特定表中达到第2048行时会被覆盖。任何帮助他都会赞赏。



提前谢谢。

Hi all,

Can anybody tell me what is the limit of the MS access database table. Bcoz i am not able to add more 2048 rows from the front end. Its a windows application wherein number of datas are added to it through interface. But the problem is the data is not getting populated beyond 2047 rows. I have 11 columns of datatype MEMO each. It gets overwritten when it reaches 2048th row in that particular table. Any help will he appreciated.

Thanks in advance.

推荐答案

在这里你可以找到定义的所有限制对于Access 2010数据库：

Access 2010规范 [ ^ ]



您应该达到上述链接中指定的限制之一。

Here you can find all limits defined for an Access 2010 database:
Access 2010 specifications[^]

You should have reached one of the limits indicated in above link.

这篇关于MS Access数据库中的表中可以添加的最大行数是多少的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！