ACC1x: "Maximum Size Reached" Error Attempting to Import File

• Microsoft Access versions 1.0, 1.1

SYMPTOMS

You receive the error message "Maximum size reached" when you attempt to import a file that increases your .MDB file size to larger than 128 megabytes (MB), or 131,072,000 bytes.

CAUSE

Although Microsoft Access version 1.1 can support databases up to 1 gigabyte (GB), Microsoft Access version 1.0 supports databases only up to 128 MB. If your .MDB file is in Microsoft Access version 1.0 format and you use it in Microsoft Access version 1.1, and then try to import data that increases your database size to larger than 128 MB, the "Maximum size reached" error message is displayed.

This error occurs because your database is still subject to the 128-MB maximum size in Microsoft Access version 1.0.

This situation typically occurs when you upgrade from Microsoft Access version 1.0 to version 1.1 and continue to use databases originally created in version 1.0, without converting the files to version 1.1 format.

RESOLUTION

To correct this problem, use the following procedure to compact your version 1.0 database file and convert it to version 1.1 format, which supports .MDB files up to 1 GB:

1. From the File menu, choose Compact Database.

2. Select the database you want to convert, and then choose OK.

3. In the File Name box, type the name of the database file.

4. In the List Files Of Type box, choose Access V1.1 (*.mdb), and then choose OK.

5. When you are prompted Replace Existing File?, choose Yes.