Table 2.3. Table Specifications and Limitations
|
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 |
Number of characters in a field property setting | 255 |