Maximum Memo Fields per table

  • Thread starter Thread starter Guest
  • Start date Start date
Hi

Based on Access 97 specifications, there is no mention of the maximum number of
memo fields in a table.

Maurice


Some common Access specifications.

Database (.mdb) file size 1 gigabyte.
However, because your database can include linked tables in other files, its
total size is limited only by available storage capacity.

Number of characters in an object name 64
Number of characters in a password 14
Number of characters in a user name or group name 20
Number of concurrent users 255
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 characters in a Text field 255
Number of characters in a Memo field 65,535 when entering data through the user
interface;
1gigabyte when entering data programmatically.

Form or report width 22 in. (55.87 cm)
Section height 22 in. (55.87 cm)
Height of all sections plus section headers (in Design view) 200 in. (508 cm)

Number of levels of nested forms or reports 3
Number of fields or expressions you can sort or group on in a report 10
Number of controls and sections you can add over the lifetime of the form or
report 754
 
Back
Top