Microsoft Access database table specifications
Attribute Maximum
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
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 oftables 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 255Number 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