Limitations and Boundaries of Access 2003
1. Size of Database file: 2GB
2. Number of objects in a database: 32,768 (215)
3. Modules (Including forms and reports with the ‘HasModule’ property set to ‘True’): 1,000
4. Number of character in an object’s Name: 64
5. Number of characters in a password: 20
6. Number of character in a username or groupname: 20
7. Number of concurrent user: 255
8. Number of character in table name: 64
9. Name of character in a field name: 64
10. Table size: 1 GB
11. Number of character in text fields: 255
12. Size of an OLE object fields: 1 GB
13. Number of index in a table: 32
14. Number of fields in an index: 10
15. Number of characters in a validation message: 255
16. Number of characters in validation rule: 2048
17. Number of characters in a field or table description: 255
18. Number of characters in a field property setting: 255
19. Number of tables in a query: 32
20. Number of fields in a recordset: 255
21. Recordset size: 1 GB
One Response to “Limitations and Boundaries of Access 2003”
rambo12 on September 2, 2010
Thanks for the information about the limitations and boundaries of Access 2003. This will give us the perfect format for Access and help us to make new access.