Caution! Back up your data before rebuilding indexes for the database files. If a problem occurs, you can restore the original data.
As you add or delete information, the amount of space required on the disk drive for storage increases. The actual data, however, might not require as much storage space. You can remove the deleted data and rebuild the indexes for the database tables thereby reducing the size of the company file on the disk drive.
When you compact database tables, Sage 100 Contractor creates a new database file using the existing file. This process requires enough space on the hard disk for two versions of the company database. After rebuilding the indexes, Sage 100 Contractor deletes the old database tables.
Important! After installing or reinstalling Sage 100 Contractor, you must rebuild the indexes of existing companies.
It is important to prevent users from accessing data while rebuilding the index. That is why you must open the company with exclusive access when you index the database.
| 1 | From the Sage 100 Contractor main window, on the File menu, click Open Company. |
| 2 | In the User Name and Password window, select the Exclusive Access check box, then log in with your user name and password. |
| 3 | From the Sage 100 Contractor main menu, select 7-4 Rebuild Indexes. |
| 4 | Click the Start button. |
| 5 | Sage 100 Contractor rebuilds the indexes. |
| 6 | When the rebuilding is complete, click the Close button. |
Note: If this is a brand new installation of Sage 100 Contractor, and you do not have a pre-existing company, you do not need to rebuild indexes.
|
|
For additional online resources for Sage 100 Contractor products, visit the Sage Customer Portal. Use the portal to access the knowledgebase, chat online with customer support, or enter a customer support ticket.
For additional training on Sage products, visit Sage University.