---
title: "Explain The Technique Used To Increase The Size Of Ms-Access Database?"  
description: "Explain The Technique Used To Increase The Size Of Ms-Access Database?"  
author: "Kalin"  
published: 2022-03-30  
canonical: https://answers.mindstick.com/qa/96622/explain-the-technique-used-to-increase-the-size-of-ms-access-database  
category: "troubleshooting"  
tags: ["troubleshooting", "ms-access"]  
reading_time: 1 minute  

---

# Explain The Technique Used To Increase The Size Of Ms-Access Database?

[Explain](https://yourviews.mindstick.com/view/86025/content-created-for-humans-not-for-bots-explain-this-statement) The [Technique](https://answers.mindstick.com/qa/102844/what-is-the-pomodoro-technique-and-does-it-work) Used To [Increase](https://yourviews.mindstick.com/view/81392/why-sudden-increase-in-corona-cases-for-india) The [Size](https://yourviews.mindstick.com/story/4792/7-differences-between-sea-and-ocean-beyond-size) Of Ms-[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

- **[SQL](https://answers.mindstick.com/qa/96637/which-is-better-mysql-or-ms-access) Server Management Studio** is a tool that allows you to manage SQL Server databases.
- To **enlarge the size of a [database](https://www.mindstick.com/articles/100/windows-service-to-update-record-from-one-database-to-another-after-certain-interval-of-time),** connect to an instance of the SQL Server Database Engine in Object Explorer and then expand that instance.
- Expand Databases, right-click the database you want to expand, and then select Properties from the drop-down menu.
- Select the Files page in Database Properties.
- Increase the value in the Initial Size (MB) column for an existing file to increase its size. You must expand the database's size by at least one megabyte.
- To expand the database's size by adding a new file, click Add and then enter the new file's values. See Add Data or Log Files to a Database for further details.
- Click the OK button.

\

**Read More: [What are joins in MS Access?](https://answers.mindstick.com/qa/96626/what-are-joins-in-ms-access)**

## \


---

Original Source: https://answers.mindstick.com/qa/96622/explain-the-technique-used-to-increase-the-size-of-ms-access-database

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