Storage limit for Access database

database
                                                                                              maximum
Microsoft   Access   database   (.mdb)   file size   2G   bytes minus the space required for the system object.
The number of objects in the database is                                          
Modules (including forms and reports with the "included module" property of "yes")   1,000
The number of characters in the object name is                                 The number of characters in the password is                                             es2010en                 14
The number of characters in a user name or group name is                                                 20
The number of concurrent users was 255en                                 255

table

Attribute   maximum
The number of characters in the table name is   64
The number of characters in the field name is   64
The number of fields in the table is   255
Number of open tables   2048; The actual number of tables that can be opened is likely to be smaller because   Microsoft   Access   also has some internal tables open.
The size of the table   2G   bytes minus the required space for the system object
The number of characters in the text field is   255
The number of characters in the "remarks" field   is entered through the user interface as   65,535; Character storage for   1G   bytes when entered programmatically.
The size of the "OLE   object" field   1G   byte
The number of indexes in the table is   32
The number of fields in the index is   10
The number of characters in the valid message is   255
The number of characters of the validity rule is   2,048
The number of characters specified in the table or field is   255
Number of characters recorded (except for the "remarks" field and the "OLE   object" field)   2,000
The number of characters set by the field property is   255

queries

Property   maximum
Number of enforcement relationships   each table is   32   minus the number of indexes in the table for fields or combinations of fields not included in the relationship
The number of tables in the query is   32
The number of fields in the recordset is   255
Recordset size   1G  
bytes Sort limit   255   characters (one or more fields)
The number of levels of nested queries is   50
Query the number of characters in a cell in the design grid   1,024
The number of parameter characters in the parameter query is   255

  or   HAVING   clause   99
The number of characters in SQL   statement   is approximately   64,000

forms and reports

Attribute   Bian most? br  /> The number of characters in the label is   2,048
The number of characters in the text box is   65,535
Form or report width   22   inches (55.87   cm)
Section height   22   inches (55.87   cm)
All sections plus the height of the section header (in the design view)   200   inches (508   cm)
The maximum number of nesting layers for a form or report is   7
The number of fields or expressions in a report that can be used as a basis for sorting or grouping Number of headers and footers in report   1   versus report header/footer, 1   versus page header/footer, 10   versus group header/group footer
The number of printed pages of the report is   65,536
The number of controls and sections that can be added to a form or report The number of characters in the record source or line source properties of a form, report, or control in the SQL statement ( .mdb   and  .adp)   32,750

macro

Property   maximum
The number of operations in a macro is   999
The number of characters in the condition is   255
Number of characters in remarks   255
The number of characters in the operation parameters is   255  

 

Microsoft   Access   project specification
Access   project

Attribute   maximum
Microsoft   Access   project   (.adp)   number of objects   32,768
Modules (including forms and reports with the "included module" property of "yes")   1,000
The number of characters in the object name is   64
The number of indexes in the table is   250   (Microsoft   SQL   Server   6.5)
1024 (Microsoft   SQL   Server   7.0   and   2000)