Compact and repair large database with Microsoft Access.

Product(s): WaterGEMS, SewerGEMS, SewerCAD, CivilStorm, StormCAD, Hammer, PondPack
Version(s): 08.11.XX.XX
Area: Layout and Data Inpue

Problem

Scenario 1

The model Database file (.mdb) is huge and takes so much time to open or save. I run the Compact Database tool under Tools menu > Database Utilities. In the CONNECT Edition releases of the products go to File > Database Utilities > Compact Database. 

Is there anything else I can do?

Scenario 2

When opening a model, the following error appears.

Unable to open user roster (HRESULT 16r80004005)

Problem ID#: 52477

Solution

On top of using the Database Utilities tools, like Compact Database and Update Database Cache, open the database file (.mdb) in Microsoft Access, and use the Compact and Repair too, in the Ribbon. This should purge data and free up space.

See Also

Compacting a database for optimal performance and general troubleshooting 

Why do I keep getting prompted to compact the database when I open my model? What does this mean? 

SQLITE database size grows very large due to Change Tracking

Anonymous
Recommended
Related