Help

Maintaining and recovering FileMaker Pro databases
F
ILEMAKER PRO HELP 1207
• If you change file recovery settings and then switch to using a script that bypasses dialog
boxes, FileMaker
Pro uses its default file recovery options (instead of those you set). If you
return to recovering files using dialog boxes, however, the changed settings are restored.
• Whenever you only want to bypass the layout to open the file, select Copy blocks as-is
and Bypass on open script, and leave other options deselected.
Troubleshooting file recovery
Use the following table to help you determine how to recover or check the consistency of a file you
suspect is damaged.
Problem Solution
Performing a find returns more records
than you expected, or the find returns
fewer records than it should. (For
example, the found set includes records
that once contained the word or value
being searched but doesn’t any longer,
or the found set doesn’t include a record
you just added with the word or value
being searched.)
The indexes for the search field (the field containing the
value being searched) have become out of sync with the
data. If the problem occurs only when searching on one
field, use the Manage Database dialog box to turn off the
field index, then save the changes, and then turn on the
field index again. To do this:
1. With the database open, choose File menu >
Manage
> Database.
2. In the Manage Database dialog box, click the
Fields tab, and double-click the indexed field.
3. In the Options for Field dialog box, click the
Storage tab.
4. Remove the index by selecting Indexing: None.
Then click OK.
5. In the Manage Database dialog box, double-click
the same field. In the Options for Field dialog box,
click the Storage tab.
6. Place the index back on for that field by selecting
Indexing: All. Click OK.
7. Click OK to close the Manage Database dialog
box.
8. Test the file.
If more than one index appears to have a problem, in the
Advanced Recovery Options dialog box, select Copy file
blocks as-is and only Rebuild indexes / Now. This
combination of options creates a new database that is a
copy of the old one with all the field indexes rebuilt.
For more information, search the FileMaker Knowledge
Base available at
http://help.filemaker.com.