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.
