• The amount of records in a table within a database is not limited by size. Forms, reports, macros, and modules all contribute to database size, albeit to a lesser extent than tables with records. Put your tables in separate database and link the tables back into the primary database if significant volumes of data will be maintained or regularly destroyed and new data entered.
• The database compression and repair functions will be substantially faster. An Access database (.accdb or.mdb) can be 2  gigabytesin size, containing all database objects and data, minus the space required for system objects.
• You can get around the size restriction by linking to tables in other Access databases. Tables in several database files, each of which can be as large as 2GB, can be linked to.

Read More: Explain About The Various Features Present In Ms Access?