For Access 2002, if you have it installed under "C\program
files", click
this link.
Database (.mdb) file size 1 gigabyte.
However, because your database can include linked tables in other files, its total size is
limited only by available storage capacity.
| Number of characters in an object name |
64 |
| Number of characters in a password |
14 |
| Number of characters in a user name or group name |
20 |
| Number of concurrent users |
255 |
| Number of characters in a table name |
64 |
| Number of characters in a field name |
64 |
| Number of fields in a table |
255 |
| Number of characters in a Text field |
255 |
| Number of characters in a Memo field |
65,535 when entering data through the user interface;
1gigabyte when entering data programmatically. |
| Form or report width |
22 in. (55.87 cm)
|
| Section height |
22 in. (55.87 cm)
|
| Height of all sections plus section headers (in Design view) |
200 in. (508 cm)
|
| Number of levels of nested forms or reports |
3 |
| Number of fields or expressions you can sort or group on in a report |
10 |
| Number of controls and sections you can add over the lifetime of the form or report
|
754 |
