Microsoft Access 2013 Inside Out

Database limitations

As you design your desktop database, you should keep in mind the following limitations:

• A table can have up to 255 fields.

• A table can have up to 32 indexes.

  Note

  Keep in mind that defining relationships with Referential Integrity turned on creates one additional index in each participating table that counts toward the 32-index limit per table.

• A multiple-field index can have up to 10 fields. The sum of the lengths of the fields cannot exceed 255 bytes.

• A row in a table, excluding Long Text fields and ActiveX objects, can be no longer than approximately 4 kilobytes (KB).

• A Long Text field can store up to 1 GB of characters, but you can’t display a Long Text larger than 64 KB in a form or a datasheet.

  Note

  Clearly, if you try to store ...