Error: "Environment error 42. All the pages in the database are in use"

This support note applies to:

AE Practice Manager (AU)
Profiles (AU)
AE Tax Series 6 & 8 (AU)

These instructions require technical expertise

Make sure you know what you're doing and are using one of the products listed. If you're not sure, ask your IT professional or MYOB.

Article ID: 29370

When opening Accountants Enterprise (AE) Tax, you may see the error "Environment error 42. All the pages in the database are in use. You need to expand the file".

This is followed by the error "Environment error 4011. Failed to insert a database record; a record already exists".

To fix this error

Ensure all users are out of MYOB Accountants Enterprise by running the Application Finder utility. For details see Running Application Finder.
Stop the Integrity.exe process. For details see Stopping and starting Integrity.
Run Database Maintenance from the data server console. For details see Running Database Maintenance in MYOB Accountants Enterprise.

Once the Database Utility has finished running, open an AE Tax return to confirm the error no longer occurs.