Problem: Personal geodatabase files increasing in size when edited with the ESRI OLE DB provider.


Repeatedly editing a personal geodatabase file with the ERSI OLE DB provider can cause the file to grow disproportionately in size.


This is a limitation of the Microsoft® Jet database engine.

Solution or Workaround

Compact the personal geodatabase .mdb file.

  1. Select the file in the Catalog Tree and right click on the object to bring up the context menu.
  2. From this menu, select Compact Database.