使用 access 的一些限制条件 (zz)

//z 2012-08-02 10:26:07 is2120@csdn.T3136396074[T16,L279,R6,V369]

Microsoft Access 2007 - 2010 Maximum Capacities

These figures are taken from Microsoft sources and published here for the convienience of my students and clients.

I don't build full applications in Access any more, but it is excellent for prototypes, and under some circumstances it works well as a front end with SQL Server as a back end. When used as a front end to SQL Server, the Access application should be an Access project.
//z 2012-08-02 10:26:07 is2120@csdn.T3136396074[T16,L279,R6,V369]

Database specifications Attribute MaximumDatabase (.mdb) file size

2 GB total for all objects in the database (data, forms, reports, indices, macros, modules, etc.)

Because your database application can be linked to tables in other mdb files or to SQL Server, application data storage can be considerably larger.

Number of objects in a database32,768Modules (including forms and reports with the HasModule property set to True)1,000Number of characters in an object name64Number of characters in a password14 (for MS Access 2003)
20 (for MS Access 2007+)Number of characters in a user name or group name20Number of concurrent users255  Table specifications Attribute MaximumNumber of characters in a table name64Number of characters in a field name64Number of fields in a table255Number of open tables2048. The actual number will be fewer because of tables opened internally by Microsoft Access.Table size2 GB minus the space needed for the system objects.Number of characters in a Text field255Number of characters in a Memo field65,535 when entering data through the user interface; 1 GB when entering data programmatically.Size of an OLE Object field1 GBNumber of indexes in a table32Number of fields in an index10Number of characters in a validation message255Number of characters in a validation rule2048Number of characters in a table or field description255Number of characters in a record (excluding Memo and OLE Object fields)4,000; 2,000 for Access 2000 and 2002Number of characters in a field property setting255  Query specifications Attribute MaximumNumber of enforced relationships32 per table minus the number of indexes that are on the table for fields or combinations of fields that are not involved in relationshipsNumber of tables in a query32Number of fields in a recordset255Recordset size1 GBSort limit255 characters in one or more fieldsNumber of levels of nested queries50Number of characters in a cell in the query design grid1,024Number of characters for a parameter in a parameter query255Number of ANDs in a WHERE or HAVING clause99Number of characters in a SQL statementapproximately 64,000  Form and report specifications Attribute MaximumNumber of characters in a label2,048Number of characters in a text box65,535Form or report width22 in.(55.87 cm)Section height22 in. (55.87 cm)Height of all sections plus section headers (in Design view)200 in. (508 cm)Number of levels of nested forms or reports7; 3for Access 2000 and 2002Number of fields or expressions you can sort or group on in a report10Number of headers and footers in a report1 report header/footer; 1 page header/footer; 10 group headers/footersNumber of printed pages in a report65,536Number of controls and sections you can add over the lifetime of the form or report754Number of characters in an SQL statement that serves as theRecordsource or Rowsource property of a form, report, or control (both .mdb and .adp)32,750  Macro specifications Attribute MaximumNumber of actions in a macro999Number of characters in a condition255Number of characters in a comment255Number of characters in an action argument255
//z 2012-08-02 10:26:07 is2120@csdn.T3136396074[T16,L279,R6,V369]