O'Reilly logo

Microsoft Office® Access 2007 Inside Out by John Viescas and Jeff Conrad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Database Limitations

As you design your 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 memo fields and ActiveX objects, can be no longer than approximately 4 kilobytes.

  • A memo field can store up to 1 gigabyte of characters, but you can’t display a memo larger than 64 kilobytes in a form or a datasheet.

    Note

    Clearly, if you try to store a 1-gigabyte ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required