Maximum capacity of Access

Source: Internet
Author: User
Tags file size header microsoft sql server sql server books ole table name access database microsoft access database
The maximum capacity of access access is in the Chinese version of Access 2000, for example. Open the Help and locate the following entry:
Set up and define Microsoft Access-> Microsoft Access specifications

Microsoft Access Database General specifications
Attribute Maximum Value
Microsoft Access database (. mdb) file size 2 G bytes. However, since the data
Libraries can include linked tables in other files, so their size is actually only available
Limits on the size of the storage space.
Number of objects in the database 32,768
Modules (including forms and reports with the HasModule property to True) 1,000
The number of characters for an object name 64
Number of characters for a password 14
Number of characters for user or group names 20
Number of users 255
Microsoft Access Project General specifications
Attribute Maximum Value
Number of objects in a Microsoft Access project (. adp) 32,768
Modules (including forms and reports with the HasModule property to True) 1,000
Number of characters in Object name 64
Microsoft Access Database Table specifications
Attribute Maximum Value
Number of characters in table name 64
Number of characters for field names 64
Number of fields in a table 255
Number of open tables 2,048. The number of tables that can actually be opened may be less, because
Microsoft Access also opens some internal tables.
Size of table 1G bytes
Number of characters in a text field 255
The number of characters in the Memo field is entered as 65,535 through the user interface, which is entered as
1G bytes.
Size of OLE Object field 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 Memo field and OLE Object field) 2,000
Number of characters set by field property 255
Microsoft Access Database Query specifications
Attribute Maximum Value
Number of implementation relationships each table is 32 minus the fields or words in the table that are not included in the relationship
Number of indexes for a segment combination
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)
Series of nested Queries 50
Number of characters in the query design grid cell 1,024
parameter query with number of parameter characters 255
Number of and in the WHERE or HAVING clause 40
The number of characters in the SQL statement is about 64,000
Form and report specifications
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)
The height of all sections plus section headers (in Design view) 200 inches (508 pct
Meters
Maximum nesting series for a form or report 7
Number of fields or expressions that can be sorted or grouped in a report 10
Number of headers and footers in Report 1 for report Header/Report footer, 1 for page Header/
Page footer, 10 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

Macro Specifications
Attribute Maximum Value
Number of actions in a macro 999
Number of characters in a condition 255
Number of characters in a note 255
Number of characters for action arguments 255

-----------------------------------------------------------------
-----------------------------------------------------------------
-----------------------------------------------------------------
Microsoft Access Project Specifications
Access Project
Attribute Maximum Value
Microsoft Access project (. adp) (Microsoft Access project: With Microsoft SQL
Server database connection and an Access file that is used to create a client/server application.
The project file does not contain any data or objects that are based on data definition, such as tables or visual
diagram). The number of objects in 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. About
For more information on SQL Server Books Online, see Microsoft Developer ' s
Network Web site.
Note using the hyperlinks in this topic jumps to the WEB, but you can always switch back to
"Help."
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 (Design view: Display
Database objects (including: tables, queries, forms, macros, and data access pages) design
Window. In Design view, you can create a new database object and modify an existing database
The design of the object. ) 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 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
Record source or row Source property as a form, report, or control in an SQL statement
Number of characters (applicable to. mdb and. adp) 32,750
Macro
Attribute Maximum Value
Macro (macro: an action or a set of actions that is used to automate a task. ) in the action
Number 999
Criteria (condition: the part of a criterion that a field must meet when searching or filtering. Some strips
The piece must be used with the value, for example, the field "author" with the Condition "equals" uses
Value "Wang Liang". "Author" "Equals" itself will be incomplete. ) the characters in
Number 255
Number of characters in notes 255
Action Arguments (Action arguments: additional information necessary for some macro operations, such as
An object that is affected or a special condition for performing an operation. ) Number of characters in 255

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.