Database Reference
In-Depth Information
The next four checkboxes are automatically turned on, but you can toggle them to provide
more refined control of the recovery process:
▪
Scan record data and rebuild fields and tables
. A corrupt field may show gibberish
where sensible text once appeared, or crash the database when clicked into, or even ab-
ruptly disappear leaving a “<field missing>” everywhere it was used. This option meticu-
lously sifts through the damage and resurrects those wayward fields whenever possible.
▪
Scan and rebuild scripts, layouts, etc
. Like the record data option, this choice provides
first aid to the file structure components.
▪
Rebuild field indexes
. Indexes are like invisible databases within a database. FileMaker
relies on them to perform finds and sorts, display related data and execute certain calcu-
lations. A classic case of index corruption is when you perform a find for a value you're
certain exists, only to have FileMaker claim no records match your request. Rebuilding
the indexes typically alleviates this problem.
▪
Delete cached settings
. If FileMaker keeps reverting to an old print setup (page setup on
the Mac) configuration no matter how often you change it, try deleting the cached set-
tings.
The final option is useful when a startup script isn't functioning as intended and you can't
seem to stop it. “Bypass startup script and layout” ignores the corresponding settings under
File→File Options, thus allowing you to take corrective measures. You must, however, pos-
sess a full access login or your attempts will be thwarted.
