The following table gives the maximum size for various attributes of a table.
Attribute | Maximum |
Number of characters in a table name | 64 |
Number of characters in a field name | 64 |
Number of fields in a table | 255 |
Table size | 1 gigabyte |
Number of characters in a Text field | 255 |
Number of characters in a Text field for double-byte character sets (DBCS), which require 2 bytes to store a single character | 127 |
Number of characters in a Memo field | 1 gigabyte |
Size of a Long Binary (OLE Object) field | 1 gigabyte |
Number of indexes in a table | 32 |
Number of fields in an index | 10 |
Number of characters in an index | 255 |
Number of characters in a validation message | 255 |
Number of characters in a validation rule | 2048 |
Number of characters in a table or field description | 255 |
Number of characters in a record (excluding Memo and OLE Object fields) | 2000 |
Number of characters in a field property setting | 255 |