UtterAccess HomeUtterAccess Wiki

Welcome Guest ( Log In | Register )

Custom Search
Edit Discussion
> Access Limits    
Access Limits

This page is under consideration for merging with: Limitations

Related Content:
    Access


Contents

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)

Edit Discussion
Custom Search
Thank you for your support!
This page has been accessed 16,166 times.  This page was last modified 03:58, 16 August 2014 by Mark Davis. Contributions by Jack Leach, Brent Spaulding and Alan Greenwood  Disclaimers