MS Access 最大属性

Microsoft Access database table specifications
Attribute Maximum

Number of characters in a table name 64

表名字符最长64字符

Number of characters in a field name 64

字段名最长64字符

Number of fields in a table 255

单表最大字段数255

Number of open tables 2048. The actual number may be less because of

tables open internally by Microsoft Access.

最大打开表数量2048.由于ACCESS后台会打开表，所以实际打开的表要少一些。

Table size 1 gigabyte

单表1GB。

Number of characters in a Text field 255

Text字段最大255字符。

Number of characters in a Memo field 65,535 when entering data through

the user interface;1 gigabyte when entering data programmatically.

用户直接使用ACCESS界面填入Memo字段最多65535字符；使用编程方式可以是1GB。

Size of an OLE Object field 1 gigabyte

OLE字段1GB。

Number of indexes in a table 32

单表index数量最大32个。

Number of fields in an index 10

单index里字段数最大10个。

Number of characters in a validation message 255
Number of characters in a validation rule 2,048
Number of characters in a table or field description 255
Number of characters in a record (excluding Memo and OLE Object fields)
2,000
Number of characters in a field property setting 255