The specifications of the Access database

Apply:ACCESS2000 ACCESS97

Database specifications are the working limits of MDB, to the following ACCESS2000 specifications, and ACCESS97 only very few differences, the difference is particularly noted.

Database

Database file size: 2 billion bytes (ACCESS97 to 1 billion bytes)

Number of components within a database: 32,768

Die Fast: 1024

Number of bytes in a component name: 64

Number of bytes in a password: 14

Total number of users: 255

Data tables

Number of bytes in a field name: 64

Number of fields in a data table: 255

Number of data tables to open account: 2,048 (ACCESS97 1,024)

Data table Size: 1 billion section words

Number of bytes in a text field: 255

The number of bytes in a Memo field: 65,535 when the user enters the data;

Input by program to 1 billion

Size of an OLE component field: 1 billion bytes

Number of indexes for a data table: 32

Number of fields in an index: 10

Number of bytes in a record (excluding OLE and memo): 2,000

Query

Number of forced associations: 32 per table, minus the number of indexes in the Data table field or field combination not included in the association.

Number of data tables for one query: 32

Number of fields in a recordset: 255

Recordset Size: 1 billion

Number of levels of nested queries: 50

Number of bytes in a cell in the query design grid: 1,024

Number of bytes in a parameter query: 255

Number of and in the WHERE or HAVING clause: 40

bytes of a SQL statement: 64,000

Getting Started with form and report programming (http://bianceng.cn)

Number of bytes in a label: 2,048

Number of bytes in a text box: 65,535

Number of bytes in form or report: 55.87 cm

Width of band: 55.87 cm

Height of all bands: 508 cm

Number of levels of nested form or report: 3

Number of fields sorted or grouped within a report: 10

Number of headers and tails in the report: 1 report headers/tails; 10 Grouped headers/tails

Number of pages to print in a report: 65,536

Number of controls or bands within a form or report: 754

Macro

Macro directive number of macros: 999

Number of bytes in a condition: 255

Number of bytes in a note: 255

Number of bytes for macro instruction parameter: 255

The above is the common specification of ACCESS2000 and ACCESS97, ACCESS2000 another new Project Data window (the file name is ADP), this kind of database specification is as follows table:

Project database can contain the number of components: 32,768

Number of modules: 1,000

Number of bytes per component name: 64