To Compress MDB Files that are Too Large



Applies To 
Product(s):OpenPlant Project Administator
Version(s):Connect Edition Update 10.09.++
Environment: Windows 10 / 11(64-bit)
Area: Specification Generator
Subarea: N/A
Original Author:Joseph Gelacio, Bentley Product Advantage Group

Background

During editing Specs in SpecGen, the MDB files are getting larger even with minimal changes.


Steps to Accomplish

  1. Take a backup copy of the .mdb file(s).
  2. After backing up the file, open each file in Microsoft Access.
  3. Go to Database Tools.
  4. Click Compact and Repair Database.
  5. Exit Microsoft Access.


    Before Compact and Repair


    After Compact and Repair





See Also

communities.bentley.com/.../how-to-perform-exchange-operation-in-openplant-specification-generator

Still a Problem?

If above problem still persists, then please create a Service Request and contact the Bentley Product Advantage group.  Please include a list of all relevant details to get in depth analysis for a solution or workaround