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.
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.
An ActiveX object can be up to 2 gigabytes in size.
There is no limit on the number of records in a table, but an Access 2007 database cannot be larger than 2 gigabytes. If you have several large tables, you might need to define each one in a separate Access database and then attach them to the database that contains the forms, reports, macros, and modules for your applications.