ACC1: Recovering MDB File Larger Than the 128-Megabyte Limit

Last reviewed: July 18, 1997
Article ID: Q96550

The information in this article applies to:

Microsoft Access version 1.0

SUMMARY

A Microsoft Access version 1.0 database (.MDB file) is limited to a maximum size of 128 megabytes (MB). However, you can exceed this limit by importing large amounts of data or by creating objects that cause the limit to be exceeded.

MORE INFORMATION

In the event a Microsoft Access database exceeds the limit, here are two options you can use to attempt to remedy the situation:

If you are able to open the database, export some of the objects to another database, and then delete them from the current database.
If you are unable to open the database, try to compact the database by using the Compact utility. It will work on files larger than 128 MB, unlike the Repair utility.

Unfortunately, there are situations where neither one of these options will work. If this is the case, you will be unable to recover the data using Microsoft Access.

REFERENCES

Microsoft Access "User's Guide," version 1.0, Appendix A, page 663

Keywords : GnlCmp kbusage
Version : 1.0
Platform : WINDOWS
Hardware : X86
Issue type : kbinfo

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: July 18, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.