Access database specification C ++

Welcome to the CC ++ programming Community Forum and interact with 2 million technical staff. Go to the Access2000 Chinese edition for help. Find the following entries to set and define microsoftAccess.

Welcome to the C/C ++ programming community forum, and interact with 2 million technical staff> go to Access 2000 Chinese edition for help, find the following entries to set and define microsoft Access-Microsoft Access specifications general specifications of Microsoft Access database ---------------------------------------------

Welcome to the C/C ++ programming Community Forum and interact with 2 million technical staff> enter

Access 2000 Chinese Version
Open Help and find the following entries
Set and define microsoft Access-> Microsoft Access specifications

General specifications of Microsoft Access database
-------------------------------------------------
Maximum Attribute Value
The size of the database (. mdb) file is 2 GB.
However, because the database can include chain tables in other files, its size is only limited by the size of available storage space.
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 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 needs to open 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 65,535 characters in the user interface and 1 GB in the program.
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
The original Article is from Delphibbs.com and is formatted by the ccrun (old demon ).
Welcome to C ++ Builder research-http://www.ccrun.com
-------------------------------------------------
Maximum Attribute Value
Number of implementation relationships: 32 for each table minus the number of indexes of fields or field combinations not contained in the relationship.
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
// 63 63 72 75 6E 2E 63 6F 6D
-------------------------------------------------
Maximum Attribute Value

65,535 characters in the text box
Form or report width & nb

[1] [2]