Sometimes I have been looking for performance issues about Access, but I can't find the Help of the MS, I can't find this article inadvertently, and share it with netizens. / / =========================================================================================================================================================================================== ============== Database specifications, how many fields can you put? . . Topic Address: http://access911.net/index.asp? Board = 4 & recordid = 72fab01e17dc access 2000 Chinese version Open help, find the following entry settings and define Microsoft Access -> Microsoft Access specification you go to the Microsoft Access database regular Specifications Maximum Value Microsoft Access Database (.mdb) file size 2 g bytes. However, since the database can include a link table in other files, its size is only limited by the available storage space. The number of objects in the database 32, 768 module (including the HasModule property is TRUE form and report) 1,000 object name character number 64 password character number 14 username or group name character number 20 users number 255MICROSOFT Access project regular Specifications Maximum Values in Microsoft Access Project (.adp) 32,768 Modules (including HasModule Attributes for True Forms and Reports) 1,000 Object Name The number of characters in characters 64MICROSOFT Access database table Specifications The maximum table name The number of 64 field names is 64 tables in the field number 255 opens the number 2,048. The number of actually open tables may be less, because Microsoft Access also opens some internal tables. Table Size 1G byte text field Character number 255 Remarks The character of the field is input to 65, 535 via the user interface, and is input to 1G byte via the program.
OLE object field Size 1G byte table Index 32 index in the field number 10 Validity message Character number 255 Validity Rule Number 2,048 Table or field Description Character number 255 recorded characters Number (In addition to the Number of Number of Number of Return Chart and OLE Object Fields) 2,000 Field Property Settings 255MICROSOFT Access Database Query Specification Attribute Maximum Value Performance Each Table 32 Decrease Table Not included in the relationship field or field combination Number of indexed numbers 32 32 Record 455 record set size 1G byte Sort by 255 characters (one or more fields) Nested query level 50 query design grid unit Character number 1,024 Parameter query parameter character number 255where or Having clause of the number 40sql statement character a number is about 64,000 Forms and report specifications attribute larger tags 2,048 text box Characters 65, 535 Forms or Report Width 22 inch (55.87 cm) Height 22 inch (55.87 cm) All sections with a height of the section page (in the design "view) 200 inch (508 cm) form or report Maximum Nested Level 7 Report Can Sort or Group Fields or Expressions 10 Reports The number of headers and footers 1 Pair of report header / report footer, 1 pair of page header / page footer 10 sets of print pages for 10 groups of page / group files 65, 536 can be added to the controls of the form or report and the number of 754 Macro Split Properties Maximum Operational number of 999 characters in the number of characters in the number of characters in the number of characters in the character of 255 Character number 255 operating parameters characters 255 -------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- ----- Microsoft Access Project Specifications Access Project Property Max Value Microsoft Access Project (.adp) (Microsoft Access Project: Connect to Microsoft SQLServer Database and use to create Access files for customer / server applications. Contains any data or data definition Objects (such as tables or views). The number of objects in objects 32, 768 (including "in-unit module" attribute is "Yes" Forms and Reports) 1,000 Object Number 64 Table Number 64 (Microsoft SQL Server 6.5) 1024 (Microsoft SQL Server 7.0 and 2000) Microsoft SQL Server Database SQL Server document describes the maximum capacity specifications of Microsoft SQL Server. For more information on SQL Server Books, see the Microsoft Developer'SNetwork Web site. Note that the hyperlink in this topic will jump to the web, but you can switch back to Help at any time. Forms and Report Attributes Max Number of characters in the maximum number of characters in the Tag 2,048 text boxes 65, 535 Forms or report width 22 inch (55.87 cm) Height 22 inch (55.87 cm) All section plus the height of the section (Design "view (" Design "view: Displays the design of the database object (including: table, query, form, macro, and data access page). In the Design view, you can create a new database object and modify the existing Design of database objects.
