Tweet
Limitations in Microsoft Access
The total size of a database file (.MDB) is limited only by the storage capacity of your PC (Microsoft® quote the maximum database size of 2 Gigabyte (2000 Megabytes)). These figures are for pre 2007 versions of Microsoft Access.
Very few realistic limitations exist, though here are some parameters:
Maximum table size 1 Gb
No. if fields in a record or table 255
No. of indexes in a table or a record 32
Ni. of fields in an index 10
No. of tables in a query 32
Maximum size of a form or report 22"
Characters in a memo field 64,000
MDB size 2 Gb
Max Integer 2,147,483,648
Concurrent Users 255
No. of characters in object names 64
The total size of a database file (.MDB) is limited only by the storage capacity of your PC (Microsoft® quote the maximum database size of 2 Gigabyte (2000 Megabytes)). These figures are for pre 2007 versions of Microsoft Access.
Very few realistic limitations exist, though here are some parameters:
Maximum table size 1 Gb
No. if fields in a record or table 255
No. of indexes in a table or a record 32
Ni. of fields in an index 10
No. of tables in a query 32
Maximum size of a form or report 22"
Characters in a memo field 64,000
MDB size 2 Gb
Max Integer 2,147,483,648
Concurrent Users 255
No. of characters in object names 64