Access 2003 - 列和行 [英] Access 2003 - Columns and Rows

问题描述

任何一个表中的最大列数和行数是多少？

What is the maximum number of columns and rows in any one table?

推荐答案

Microsoft Access规范

您拥有的记录数量不受限制，但您有大小限制。

Microsoft Access Specifications
You are unlimited in the number of records you have, but you have a size limit.

Microsoft Access规范
您拥有的记录数量不受限制，但您有大小限制。

Microsoft Access Specifications
You are unlimited in the number of records you have, but you have a size limit.

谢谢快速回复！好的，大小和我如何计算？我有一个包含1MM记录和25列的表以及另一个包含5000条记录和100列的主表。大多数数据是文本和日期类型。整个数据库现在是500mb。我想在100列表中添加更多列，这会不会引起我的问​​题？

THanks for the quick reply! OK, what size and how do i figure that? I have one table with 1MM records and 25 columns and another main table with 5000 records and 100 columns. Most of the data is text and date type. The entire db is 500mb now. I want to add more columns to the 100 column table, will this cause me a problem down the road?

好吧，如果你去了链接，它会给你信息你需要。每个数据库255列和2千兆字节。

Well, if you went to the link, it''d give you the information you needed. 255 columns and 2 gigabytes per database.

这篇关于Access 2003 - 列和行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！