Upper Limit of Access database storage

Database
Maximum Attribute Value
The size of the Microsoft Access database (. mdb) file is 2 GB, minus the space required by the system object.
32,768 objects in the database
Module (including forms and reports with the "embedded module" attribute "yes") 1,000
64 characters in the object name
The number of characters in the password is 14
The username or group name contains 20 characters.
255 concurrent users

Table

Maximum Attribute Value
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.
The number of opened tables is 2048; the actual number of opened tables may be less, because Microsoft Access also needs to open some internal tables.
The table size is 2 GB bytes less space required by the System Object
The "text" field contains 255 characters
The number of characters in the remarks field is set to 65,535 on the user interface, and the number of characters in 1G is stored in programming.
The size of the "OLE object" field is 1 GB.
The number of indexes in the table is 32.
10 fields in the Index
The number of valid messages is 255 characters.
The validity rule contains 2,048 characters.
The table or field description contains 255 characters.
The number of characters recorded (except the "Remarks" field and the "OLE object" field) is 2,000.
The number of characters set for the field attribute is 255.

Query

Maximum Attribute Value
Number of implementation relationships: 32 for each table minus the number of indexes of fields or field combinations not contained in the relationship.
The number of tables in the query is 32.
255 fields in the record set
Record set size: 1 GB
Sorting is limited to 255 characters (one or more fields)
Number of nested query levels 50
The number of characters in a cell in the query design grid is 1,024.
The number of parameters queried is 255 characters.
The number of AND in the Where or HAVING clause is 99.
The SQL statement contains about 64,000 characters.

Forms and reports

What is the highest attribute? Br/> the tag contains 2,048 characters
65,535 characters in the text box
Form or report width 22 inch (55.87 cm)
Section height 22 inch (55.87 cm)
Add the height of the section header to all sections (in the design view) 200 inch (508 cm)
Maximum number of nested layers of forms or reports 7
The number of fields or expressions that can be used as sorting or grouping in the report is 10.
Number of headers and footers in a report: 1 to report Header/report footer, 1 to page header/footer, and 10 to group Header/group footer
65,536 page number of printed reports
The number of controls and sections that can be added to a form or report is 754.
Number of Characters in the "record source" or "Row source" attribute of a form, report, or control in an SQL statement (applicable to. mdb and. adp) 32,750

Macro

Maximum Attribute Value
The number of operations in the macro is 999.
255 characters in the condition
255 characters in remarks
The number of characters in the operation parameter is 255.



Microsoft Access Project Specification
Access Project

Maximum Attribute Value
The number of objects in Microsoft Access Project (. adp) is 32,768
Module (including forms and reports with the "embedded module" attribute "yes") 1,000
64 characters in the object name
The number of indexes in the table is 250 (Microsoft SQL Server 6.5)
1024 (Microsoft SQL Server 7.0 and 2000)