General specifications of Microsoft Access databases

Source: Internet
Author: User
Tags microsoft access database
General specifications of Microsoft Access databases

General specifications of Microsoft Access database

The size of the Microsoft Access 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


Microsoft Access database table Specification
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 less, because Microsoft Access
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.

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.