The Rebuild Key Files utility repairs and optimizes application data in Sage 100. You need the right role permissions to access this feature. The process includes scanning, rebuilding, and saving backup files. For Sage 100 Premium (SQL), use database maintenance instead.

Verify role permissions

1. Open Library Master, Main, Role Maintenance.
2. Select the user’s Role.
3. Go to the Tasks.
4. Expand Library Master, Miscellaneous Tasks.
5. Make sure you check Rebuild Key Files.
6. Go to the Security Events.
7. Expand Library Master.
8. Make sure you check Allow User to Access File Maintenance Utilities.
9. Click Accept.

Run Rebuild Key Files

4. Go to Library Master, Utilities, Rebuild Key Files.
5. Read the warning message.
   • Click OK if you’re familiar with the utility
   • Click Cancel if you’re not, and contact Sage support
6. In the Rebuild Application Key Files window:
   • Select the company code and module
   • Check the Rebuild box for files to rebuild, or click Select All
   • Choose rebuild options
     • Integrity Check: Validates records and data dictionaries. Launches a Notepad report
     • Optimize File: Rewrites and arranges keys. Launches a Notepad report
     • Scan Files: Shows records to recover before rebuilding
     • Save Original File: Automatically selected. Creates a backup (.OLD file)
     • Click Proceed
7. If you selected Scan Files, review the scan results.
8. If you selected Scan Files, review the scan results.
   
   • Click Yes if most records will be recovered
   • Click No if you lose many records.  Seek assistance to determine why so many records are damaged 
   • In the Error Log window, click Print or Preview. Save the log for reference
   • When the window reappears, click Cancel to close
9. After the rebuild is complete, run the Rebuild Sort Files utility for the module.

For Sage 100 Premium (SQL)

You can't rebuild key files. Use SQL Server maintenance plans.

How to Rebuild Sort Files
How to Analyze and Relink Line Files
How To Rebuild Sage 100 Premium Tables