Maximum access capacity

Sometimes I was looking for access performance problems, but I couldn't find them with the help of MS Office. I accidentally found this article and shared it with netizens.

// ================================================ ======================================

Database specification problems, such as how many fields can be placed in a table, and how big...

Theme address: http://access911.net/index.asp? Board = 4 & recordid = 72fab01e17dc

Access 2000 Chinese Version
Open Help and find the following entries
Set and define Microsoft Access-> Microsoft Access specifications
Go and check it out.
General specifications of Microsoft Access database
Maximum Attribute Value
The size of the Microsoft Access database (. mdb) file is 2 GB. However, due to data
Library can include chain tables in other files, so its size is only available
The size of the bucket.
32,768 objects in the database
Module (including forms and reports whose hasmodule attribute is true) 1,000
Object Name characters 64
The number of characters in the password is 14
The username or group name contains 20 characters.
255 users
General specifications of Microsoft Access
Maximum Attribute Value
The number of objects in the Microsoft Access Project (. ADP) is 32,768
Module (including forms and reports whose hasmodule attribute is true) 1,000
The number of characters in the object name is 64
Microsoft Access database table Specification
Maximum Attribute Value
The number of characters in the table name is 64.
The number of characters in the field name is 64.
255 fields in the table
The number of opened tables is 2,048. The actual number of opened tables may be smaller, because
Microsoft Access also opens some internal tables.
The table size is 1 GB.
The number of characters in a text field is 255.
The number of characters in the remarks field is entered as 65,535 on the user interface and
1 GB.
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.
Microsoft Access database query Specification
Maximum Attribute Value
Number of implementation relationships: 32 for each table minus the fields or words that are not included in the relationship.
Segment combination index count
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)
Level 50 of nested queries
The number of characters in the query design grid unit is 1,024.
The number of parameters queried is 255 characters.
The number of and in the where or having clause is 40.
The SQL statement contains about 64,000 characters.
Form and report specifications
Maximum Attribute Value
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)
Height of the section header added to all sections (in the design view) 200 inch (508
Meters)
Maximum nested level 7 of a form or report
10 fields or expressions that can be sorted or grouped in a report
Number of headers and footers in a report: one for the report Header/report footer, and one for the page header/
Page footer, 10 groups of headers/groups of footers
65,536 page number of printed reports
The number of controls and sections that can be added to a form or report is 754.

Macro Specification
Maximum Attribute Value
The number of operations in the macro is 999.
255 characters in the condition
The number of annotated characters is 255.
The number of operation parameters is 255 characters

-----------------------------------------------------------------
-----------------------------------------------------------------
-----------------------------------------------------------------
Microsoft Access Project Specification
Access Project
Maximum Attribute Value
Microsoft Access Project (. ADP) (Microsoft Access Project: with Microsoft SQL
Server database connection and used to create access files for client/server applications.
The project file does not contain any data or data-defined objects (such as tables or
Figure ).) The number of objects in 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)

Microsoft SQL Server database
The SQL Server document describes the maximum capacity of Microsoft SQL Server. Related
For more information about SQL Server books online, see Microsoft developer's
Network web site.
Note that using the hyperlink in this topic will jump to the Web, but you can switch back at any time
"Help ".
Forms and reports
Maximum Attribute Value
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 ("design" View: Display
Designed for database objects (including tables, queries, forms, macros, and data access pages)
Window. In the design view, you can create database objects and modify existing databases.
Object design .) Moderate) 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: one for the report Header/report footer, and one for the page header/
Page footer, 10 pairs of group headers/group footers
65,536 page number of printed reports
The number of controls and sections that can be added to a form or report is 754.
The "record source" or "Row source" attribute in an SQL statement as a form, report, or control
The number of characters (applicable to. MDB and. ADP) 32,750
Macro
Maximum Attribute Value
Macro (macro: an operation or a group of Operations used to automatically execute a task .) Operation in
Several 999
Condition (condition: part of the criteria that must be met by the field during search or filtering. Items
Must be used together with the value. For example, use the field "author" with the condition "equal"
The value is "Wang Liang ". "Author" and "equal" will be incomplete .) Characters in
Number 255
255 characters in remarks
Operation parameters (operation parameters: other information required for some macro operations, such
Objects affected or special conditions for performing operations .) The number of characters in 255

 

--
Common progress