File Maintenance

Recalculate

When you press any of these four buttons, File Maintenance performs a sweep of your database to look for errors. You cannot harm your database by pressing any of these buttons, and in general you would not see any results. That is, the sweep would finish and return you to the File Maintenance box. You would want to run these when you:

1.After changing data directly in the database via Access

2.After manual conflict resolution in TntSync (as anomalies may occur)

Other Items

Checks for duplicates by analyzing first names and last names. Notice in this example that Barney Rubble has been entered twice, once as Barney and once as Barnie.

Check for Duplicates will not make changes, but will offer a lookup for these contacts:

Tip: Check for Duplicates

TntMPD can check for possible duplicates in your list, using the same logic it does when downloading a contact for the first time from your organization.

Menu Path: File | Maintenance

Read More > File Maintenance

Clicking on Fix RTF Notes will automatically detect and fix this formatting codes in the Notes field where it occurs. (Very rare)

File Maintenance will search your database for contacts who have titles or first names combined in one field. This most commonly occurs when a user imports an existing contact list.

File Maintenance can perform a rebuild of your database. This is a more time-consuming sweep as TntMPD will analyze every gift and every contact individually. You cannot harm your database by performing this procedure, but there is also no reason to perform this maintenance step on a regular basis.

What actually happens:

1.TntMPD creates a brand new database.

2.TntMPD copies all the records from your old database into this new database.

3.TntMPD deletes the old database and renames the new database to match your old one.

How does this compare to "Compact and Repair Database"?

Read More > Compact & Repair Database

1.They are similar in that they both create new databases and copy records.

2.Compact Database creates a new database using the structure from your old database (which might be corrupted).

3.Rebuild Database is “deeper” in that it can restore lost indexes and other TntMPD-specific structures that Compact and Repair might miss.

4.Rebuild Database ensures that your database is exactly as TntMPD expects it.

5.Rebuild Database takes longer.