What Is The Size Limitation Of An Access Database?

0 votes
asked May 27, 2017 in MS Access Issues by Lawis
What’s the maximum size of access database as I am continuously getting reached size limit error? Is there is any option to increase this limit? It’s important for me, so anyone having solution then please share.

1 Answer

0 votes
answered May 27, 2017 by lucy (980 points)

Size limitation does not pertain to number of records in a table within a database. Forms, reports, macros and modules also contribute to database size but rather than this minimal compared to tables containing records. It is recommended that if large amounts of data will be maintained or constantly deleted and new data imported, put your tables in another database and link the tables back into the main database. The utilities for database compression and repair will run much more quickly. In access 2.0 databases the byte size limitation is 2 Gigabytes. The limit applies to both .mdb files and the newer Access database format files .accdb

If you access database has reached that limit then you have number of options to increase it. One option is to split the front-end database form the back-end database. This is called a split database. You can then link more than one back-end database to the front end database with each back-end database of size 2 GB.

Welcome to Q&A - Access Repair N Recovery, where you can ask questions and receive answers from other members of the community.