Microsoft Access database (. mdb) file size 2 G bytes. However, because the database can include linked tables in other files, its size is only actually limited by the amount of available storage space.
Number of objects in the database 32,768
Modules (including forms and reports with the HasModule property to True) 1,000
The number of characters for an object name 64
Number of characters for a password 14
Number of characters for user or group names 20
Number of users 255
Microsoft Access Database Table specifications
Number of characters in table name 64
Number of characters for field names 64
Number of fields in a table 255
Number of open tables 2,048. The number of tables that can actually be opened may be less, because Microsoft Access
You also need to open some of the internal tables.
Size of table 1G bytes
Number of characters in a text field 255
The number of characters in the Memo field is entered as 65,535 through the user interface and is entered as 1G bytes by the program.
Size of OLE Object field 1G bytes
Number of indexes in a table 32
Number of fields in the index 10
Number of characters for a validation message 255
Number of characters for a validation rule 2,048
Number of characters in a table or field description 255
Number of characters in the record (except Memo field and OLE Object field) 2,000
Number of characters set by field property 255
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.
