Access stores data limits

access| storage limit for data Access databases
Access Specifications
Microsoft Access Database Specifications
Access Database



Attribute Maximum Value
The Microsoft Access database (. mdb) file size is 2G bytes minus the space required for system objects.
Number of objects in the database 32,768
Modules (including forms and reports with the "containing modules" property "Yes") 1,000
The number of characters in the object name is 64
Number of characters for a password 14
Number of characters for user or group names 20
Number of concurrent users 255



Table



Attribute Maximum Value
Number of characters in table name 64
Number of characters for field names 64
Number of fields in a table 255
The number of open tables is 2048; The number of tables that can actually be opened may be less, because Microsoft Access also opens some internal tables.
Table size 2G bytes minus the space required for system objects
Number of characters in the text field 255
The number of characters in the Memo field is entered as 65,535 through the user interface, and the character store for 1G bytes is entered programmatically.
The size of the OLE object field is 1G bytes
Number of indexes in a table 32
Number of fields in the index 10
Number of characters for a validation message 255
Number of characters for a validation rule 2,048
Number of characters in a table or field description 255
Number of characters in the record (except for the Memo field and the OLE object field) 2,000
Number of characters set by field property 255



Inquire



Attribute Maximum Value
Number of implementation relationships each table is 32 minus the number of indexes in a field or combination of fields that are not included in the relationship in the table
Number of tables in a query 32
Number of fields in a recordset 255
Recordset size 1G bytes
Sort limit 255 characters (one or more fields)
Number of levels of nested queries 50
Number of characters in a cell in the query design grid 1,024
parameter query with number of parameter characters 255
Number of and in the WHERE or HAVING clause 99
The number of characters in the SQL statement is about 64,000



Forms and reports



Attribute Maximum Value
Number of characters in the label 2,048
Number of characters in a text box 65,535
form or report width 22 inches (55.87 cm)
Section height 22 inches (55.87 cm)
Height of all sections plus section headers (in Design view) 200 inches (508 cm)
Maximum number of nesting levels for a form or report 7
Number of fields or expressions on a report that can be sorted or grouped by 10
Number of headers and footers in Report 1 for report Header/Report footer, 1 for Page Header/page footer, 10 for group header/group footer
Printed page 65,536 of report
Number of controls and sections that can be added to a form or report 754
Number of characters in the SQL statement that are the record source or row Source property of a form, report, or control (applicable to. mdb and. adp) 32,750



Macro



Attribute Maximum Value
Number of actions in a macro 999
Number of characters in a condition 255
Number of characters in notes 255
Number of characters in action arguments 255




Microsoft Access Project Specifications
Access Project



Attribute Maximum Value
Number of objects in Microsoft Access project (. adp) 32,768
Modules (including forms and reports with the "containing modules" property "Yes") 1,000
The number of characters in the object name is 64
Number of indexes in table (Microsoft SQL Server 6.5)
1024 (Microsoft SQL Server 7.0 and 2000)




Microsoft SQL Server Database



The maximum capacity specification for Microsoft SQL Server is described in the SQL Server documentation. For more information about SQL Server Books Online, see the Microsoft Developer ' s network Web site.



Note using the hyperlinks in this topic jumps to the WEB, but you can switch back to help at any time.



Forms and reports



Attribute Maximum Value
Number of characters in the label 2,048
Number of characters in a text box 65,535
form or report width 22 inches (55.87 cm)
Section height 22 inches (55.87 cm)
Height of all sections plus section headers (in Design view) 200 inches (508 cm)
Maximum number of nesting levels for a form or report 7
Number of fields or expressions on a report that can be sorted or grouped by 10
Number of headers and footers in Report 1 for report Header/Report footer, 1 for Page Header/page footer, 10 for group header/group footer
Printed page 65,536 of report
Number of controls and sections that can be added to a form or report 754
Number of characters in the SQL statement that are the record source or row Source property of a form, report, or control (applicable to. mdb and. adp) 32,750



Macro



Attribute Maximum Value
Number of actions in a macro 999
Number of characters in a condition 255
Number of characters in notes 255
Number of characters in action arguments 255