---
title: "What Is The Size Limitation Of An Access Database?"  
description: "What Is The Size Limitation Of An Access Database?"  
author: "Sanjay Goenka"  
published: 2022-03-31  
canonical: https://answers.mindstick.com/qa/96630/what-is-the-size-limitation-of-an-access-database  
category: "troubleshooting"  
tags: ["troubleshooting", "ms-access"]  
reading_time: 1 minute  

---

# What Is The Size Limitation Of An Access Database?

What Is The [Size](https://yourviews.mindstick.com/story/4792/7-differences-between-sea-and-ocean-beyond-size) Limitation Of An [Access Database](https://www.mindstick.com/forum/468/what-is-the-way-for-finding-out-whether-a-table-exists-in-the-microsoft-access-database)?

## Answers

### Answer by Hitesh Vohra

- The amount of records in a table within a [database](https://www.mindstick.com/articles/100/windows-service-to-update-record-from-one-database-to-another-after-certain-interval-of-time) 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 gigabytes**in 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?](https://answers.mindstick.com/qa/96635/explain-about-the-various-features-present-in-ms-access)**


---

Original Source: https://answers.mindstick.com/qa/96630/what-is-the-size-limitation-of-an-access-database

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.