Microsoft Access Database (.mdb) File size 2 G bytes. However, since the database can include linked tables in other files, its size is only really limited by the size of available storage space.
The number of objects in the database is 32,768
Module (including forms and reports with HasModule attribute True) 1,000
64 characters in the object name
The number of characters in the password is 14
The number of characters in the user name or group name is 20
Number of users 255
Microsoft Access Database Table Specifications
The number of characters in the table name is 64
The number of characters in the field name is 64
The number of fields in the table is 255
The number of open tables is 2,048. The actual number of tables that can be opened may be smaller, because Microsoft Access
Also open some internal tables.
Table size 1G bytes
The number of characters in the text field is 255
The number of characters in the note field is input to 65,535 through the user interface and 1G bytes through the program.
OLE object field size 1G byte
The number of indexes in the table is 32
The number of fields in the index is 10
The number of characters in the validity message is 255
The number of characters in the validity rule is 2,048
The number of characters in the table or field description is 255
Number of characters recorded (except the comment field and the OLE object field) 2,000
The number of characters set by field attribute is 255
The number of objects in the database is 32,768
Module (including forms and reports with HasModule attribute True) 1,000
64 characters in the object name
The number of characters in the password is 14
The number of characters in the user name or group name is 20
Number of users 255
Microsoft Access Database Table Specifications
The number of characters in the table name is 64
The number of characters in the field name is 64
The number of fields in the table is 255
The number of open tables is 2,048. The actual number of tables that can be opened may be smaller, because Microsoft Access
Also open some internal tables.
Table size 1G bytes
The number of characters in the text field is 255
The number of characters in the note field is input to 65,535 through the user interface and 1G bytes through the program.
OLE object field size 1G byte
The number of indexes in the table is 32
The number of fields in the index is 10
The number of characters in the validity message is 255
The number of characters in the validity rule is 2,048
The number of characters in the table or field description is 255
Number of characters recorded (except the comment field and the OLE object field) 2,000
The number of characters set by field attribute is 255