Others

How to Fix Access 97 Database Reaching the 1 GB Size Limit

Olivia MillerOlivia Miller Oct 19, 2026 869 views

Question details

The user is unable to compact a Microsoft Access 97 database because it has hit the maximum 1 GB file size limit, and the operation fails to complete.

How to Fix an Access 97 Database That Has Reached the 1 GB Size Limit
Product
Microsoft Access 97
Device & OS
not provided
Scenario
Attempting to run the Compact and Repair utility on an oversized database to reorganize the file and free up unused disk space.
Observed behavior
The compacting process stalls or fails to finish because Microsoft Access lacks the necessary free space within the file limit or hard drive to create the compacted copy.
Before you start

Ensure your computer's hard drive has plenty of free space (at least 2 GB), as database recovery and importing processes require temporary storage space to safely duplicate your data.

Solution 1Recommended

Import Objects into a New Blank Database

This method bypasses the compacting error by moving your existing tables, forms, and queries into a fresh, unfragmented database file.

When an Access file reaches its size limit, it often contains hidden unused space from deleted records or temporary objects. Importing your data into a completely new file forces the database engine to write only the active data, effectively compressing the total file size without triggering the standard Compact tool.

1
Create a New File

Open Microsoft Access and select 'Blank Database' to create a new .mdb file. Save it to your desired folder.

2
Open the Import Wizard

Navigate to the 'File' menu, select 'Get External Data', and then click on 'Import'.

3
Select the Oversized Database

Browse to the location of your bloated Access 97 database file, select it, and click 'Import'.

4
Import All Objects

In the Import Objects dialog box, go through each tab (Tables, Queries, Forms, Reports, Macros, Modules), click 'Select All' for each, and then click 'OK' to bring them into the new database.

Import Objects into a New Blank Database
Size Reduction: Once the import is complete, check the file size of your new database. It should be significantly smaller than the original 1 GB file.
Free Microsoft Office alternative

Looking for a Lightweight and Free Office Suite? Try WPS Office

If you are tired of encountering frustrating file size limits and outdated software errors, consider streamlining your workflow. While Access is used for complex relational databases, everyday data tracking, lists, and forms are often managed much more efficiently in robust spreadsheet software. WPS Office provides a highly compatible, lightweight, and entirely free alternative to Microsoft Office for your core document and data management needs.

Seamlessly compatible with Microsoft Excel (.xlsx), Word (.docx), and PowerPoint (.pptx) formats.Powerful spreadsheet capabilities in WPS Spreadsheet to manage and filter large datasets without the 1 GB file bloat issues of legacy databases.Lightweight installation that requires significantly less hard drive space and system memory.Completely free core features with a familiar, easy-to-navigate user interface.
microsoft office alternative - wps office

Frequently Asked Questions

What is the maximum file size limit for an Access 97 database?

Microsoft Access 97 has a strict file size limit of 1 GB (Gigabyte) for a single database file (.mdb). If the file attempts to grow beyond this limit, you will encounter errors, and data corruption may occur. Newer versions of Microsoft Access increased this limit to 2 GB.

Why does compacting an Access database require extra disk space?

When you run the Compact and Repair tool, Access creates a temporary new copy of the database file. It rewrites all objects and data to this new file to eliminate fragmented or unused space. Therefore, you need available disk space that is at least equal to, if not slightly larger than, the size of your current database.

How does splitting an Access database help prevent size limit errors?

Splitting a database divides the architecture into two separate files: a back-end containing only the data tables, and a front-end containing the queries, forms, and reports. By dividing the load, you effectively double your size limit headroom and significantly improve network performance for multiple users.

Can I convert my Access 97 database to a newer version to increase the size limit?

Yes. Converting your legacy .mdb file to the newer .accdb format using a modern version of Microsoft Access (2007 or later) will automatically increase the maximum file size limit from 1 GB to 2 GB.