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.

Note:

• 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.