Tables have a number of specifications and limitations as well. Although you will generally not find them restricting, you should keep them in mind. They are listed in Table 2.3:
Item | Limitation |
|---|---|
Number of characters in a table name | 64 |
Number of characters in a field name | 64 |
Number of fields in a table | 255 |
Number of open tables | 2048; the actual number is less because of tables opened internally by Microsoft Access |
Table size | 2 gigabytes minus the space needed for system objects |
Number of characters in a text field | 255 |
Number of characters in a memo field | 65,535 when entering data through the user interface; 1 gigabyte of character storage when entering data programmatically |
Size of an OLE Object field | 1 gigabyte |
Number of indexes in a table | 32 |
Number of fields in an 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 |
255 |
You also have the ability to save table data under the XML format.