Maximum in MS Access 2003

Related to Database

• Microsoft Access database (.mdb) file size
  2 gigabytes minus the space needed for system objects.
• Number of objects in a database
  32,768
• Modules (including forms and reports with the HasModule property set to True)
  1,000
• 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

Related to Tables

• 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 may be less because of tables opened internally by Microsoft Access
• Table size
  2 gigabyte minus the space needed for the 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) when the UnicodeCompression property of the fields is set to Yes
  4,000
• Number of characters in a field property setting
  255

Maximum related to query

• Number of enforced relationships
  32 per table minus the number of indexes that are on the table for fields or combinations of fields that are not involved in relationships
• Number of tables in a query
  32
• Number of fields in a recordset
  255
• Recordset size
  1 gigabyte
• Sort limit
  255 characters in one or more fields
• Number of levels of nested queries
  50
• Number of characters in a cell in the query design grid
  1,024
• Number of characters for a parameter in a parameter query
  255
• Number of ANDs in a WHERE or HAVING clause
  99
• Number of characters in an SQL statement approximately
  64,000

Maximum related to form and report

• Number of characters in a label
  2,048
• Number of characters in a text box
  65,535
• 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
  7
• Number of fields or expressions you can sort or group on in a report
  10
• Number of headers and footers in a report
  1 report header/footer;
  1 page header/footer;
  10 group headers/footers
• Number of printed pages in a report
  65,536
• Number of controls and sections you can add over the lifetime of the form or report
  754
• Number of characters in an SQL statement that serves as the Recordsource or Rowsource property of a form, report, or control (both .mdb and .adp)
  32,750

 Access Limitations related to Macros

• Number of actions in a macro
  999
• Number of characters in a condition
  255
• Number of characters in a comment
  255
• Number of characters in an action argument
  255

Hope this helps in your studies.