Configuring the JET engine threshold for Personal Geodatabases

If you are editing large numbers of features in a personal geodatabase, you can change the JET engine max # of records to calculate advanced setting in ArcMap to accommodate a higher limit for the number of edits before saving an edit session.

NoteNote:
  • This change is recommended because if the number of edits made is greater than the threshold, all edits will be lost.
  • This is mostly relevant for bulk updates. The suggested value for the threshold is dependent on your editing cycle.
Steps:
  1. Navigate to the Program Files\ArcGIS\Desktop10.0\Utilities directory.
  2. Double-click AdvancedArcMapSettings.exe.

    The Advanced ArcMap Settings dialog box appears.

  3. Click the Editor tab.
  4. Type a new value in the JET engine max # of records to calculate text box.

    It is suggested that the number be approximately 100000 (100 thousand).

  5. Click Apply.
  6. Click the X in the upper right-hand corner to close the dialog box.

8/12/2010