Access Limits
|
| |
This page is under consideration for merging with: Limitations |
Related Content:
Access
Limits and Maximum Values
General Information
The following list applies to Microsoft Access 2007, but is generally applicable to earlier versions also. Any differences between Microsoft Access 2007 and previous versions are noted in the appropriate definition
Access Specifications
| Access database (*.mdb or *.accdb) file size
| 2 gigabytes, including all objects in the database (data, forms, reports, indices, macros, modules, etc.). However, because your database can include linked tables in other files, its total size is limited only by available storage capacity. 1 gigabyte for Access 97. See also: Linking to Multiple Backends
|
| Total number of concurrent users
| 255. Note that the practical limit will likely be lower than this based on database design.
|
| Number of objects in a database
| 32,768
|
| Modules (including forms and reports with the HasModule property set to True)
| 1000
|
| 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.
|
Table Specifications
| Number of tables
| This is governed by a limit on the number of objects in the database, which includes tables, forms, reports, queries, etc. The limit on DB objects is 32,768.
|
| Table size
| 2 gigabytes, less the space needed for system objects. 1 gigabyte for Access 97
|
| 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. Note that this includes internal tables opened by Access.
|
| Number of characters in a text field
| 255
|
| Number of characters in a memo field
| 65,535 when text is entered through the UI. If the Memo field is manipulated through DAO (or ADO) and only text and numbers [not binary data] will be stored in it, then the size of the Memo field is limited by the size of the database.
For Access 2003, limitation is 1 gigabyte of character storage when entering data programmatically)
|
| Size of an OLE Object field
| 1 gigabyte
|
| Number of indexes on a table (effected by enforced relationships - See Query section)
| 32
|
| Number of fields in an index or primary key
| 10
|
| Number of characters in a validation rule
| 2048
|
| Number of characters in a validation message
| 255
|
| Number of characters in a record (excluding Memo and OLE Object fields) when the UnicodeCompression property is set to Yes.
| 4000. 2000 without that property or if the property is set to No
|
| Number of characters in a field property setting
| 255
|
Query Specifications
| 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 returned by a query
| 255
|
| Maximum 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
| 1024
|
| Number of characters in a parameter in a parameterized query
| 255
|
| Number of ANDs in a WHERE or HAVING clause
| 99. 40 for Access 97
|
| Number of characters in a SQL statement
| Approx 64,000
|
Form and report specifications
| Number of characters in a label
| 2048
|
| Number of characters in a text box
| 65535
|
| Form or report width
| 22 inches (55.87cm)
|
| Section height
| 22 inches (55.87cm)
|
| Height of all sections, plus section headers in design view
| 200 inches (508 cm) Note an actual report can be arbitrarily long once the data has expanded.
|
| Number of levels of nested forms or reports
| 7. 3 for Access 2000 and 2002/2003
|
| Number of fields or expressions that can be sorted or grouped in a report
| 10
|
| Number of headers or footers in a report
| 1 report header / footer 1 page header / footer 10 section headers / footers
|
| Number of printed pages in a report
| 65535
|
| Number of controls and sections added over the lifetime of a form / report
| 754
|
| Number of characters in a SQL statement that serves as the Recordsource or Rowsource property of a form, report, or control
| 32750
|
Macro and VBA Specifications
| 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
|
| Number of modules (includes forms and reports with the HasModule property set to True)
| 1000
|
For more information or varification, search the Access Help on the key term 'Access Specifications' or visit the following links:
Access 2003 Specifications (MDB)
Access 2007 Specifications (ACCDB)
Access 2010 Specifications (ACCDB)
Access Limits
