What is the maximum storage space of an Access database?

Database
Properties                                                                                                                                                 ’s ’s ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐                                                                                                       to
ObjectRequired space. The number of objects in the database 32,768
module (including the window and report of the "inner module" attribute "yes") 1,000
The number of characters in the name of the object 64
Number of characters 14
The number of characters in the user name or group name 20
The number of concurrent users                           255


Table
Attribute Maximum Value
Table The number of characters in the name 64
The number of characters in the field name 64
The number of fields in the table 255
The number of open tables 2048; the actual number of open tables may be less, because Microsoft Access also opens some internal tables.
The size of the table 2G bytes minus the space required for system objects
The number of characters in the "Text" field 255
The number of characters in the "Remarks" field entered through the user interface is 65,535; with
ProgrammingThe character storage is 1G bytes when input. The size of the "OLE object" field 1G bytes

Indices in the tableNumber 32 Number of fields in the index 10
Number of characters in the validity message 255
The number of characters in the validity rule 2,048
The number of characters in the table or field description 255
The number of characters in the record (except the "Remarks" field and the "OLE Object" field) 2,000
Field The number of characters set in the attribute is 255


Query
Attribute Maximum value
The number of implemented relationships is 32 for each table minus Number of indexes for fields or field combinations in the table that are not included in the relationship
Number of tables in the query 32
Number of fields in the record set 255
Record set size 1G bytes
Sorting Limit 255 characters (one or more fields)
The number of levels of nested queries 50
The number of characters in a cell of the query design grid 1,024
The number of parameter characters for parameter queries 255
The number of AND in the Where or HAVING clause is 99
The number of characters in the SQL statement is approximately 64,000


Forms and reports
Attributes are the best ?br />Number of characters in label 2,048
Number of characters in 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
Can be in a report The number of fields or
expressions used as the basis for sorting or grouping 10 The number of headers and footers in the report is 1 pair of report header/report footer, 1 pair of page header/page footer, 10 pairs of group header/group footer
The number of printed pages of the report 65,536
The number of controls that can be added to the form or report and sections 754
The number of characters in the SQL statement as the "record source" or "row source" attribute of the form, report, or control (Applicable to .mdb and .adp) 32,750

Macro

Attribute Maximum value
The number of operations in the macro 999
The number of characters in the condition Number 255
The number of characters in the remark 255
The number of characters in the operation parameter 255



Microsoft Access Project Specifications
Access Project

Attribute Maximum value
The number of objects in a Microsoft Access project (.adp) 32,768
Modules (including forms and reports with the "Contains Modules" property set to "Yes") 1,000
The number of characters in the object name 64
The number of indexes in the table 250 (Microsoft SQL Server 6.5)
1024 (Microsoft SQL Server 7.0 and 2000)

[Related recommendations]

1. Mysql free video tutorial

2. Teach you how to start and stop the Mysql service Part 2

3. Teach you how to start and stop one of the Mysql services

4. Example tutorial for processing special sql statements in mysql

5. Delete table Detailed explanation of how to write SQL statements in different databases

The above is the detailed content of What is the maximum storage space of an Access database?. For more information, please follow other related articles on the PHP Chinese website!