How do we run the Reorganizing tool?

Reorganize after your daily backup.

Reorganize after your daily backup.

Reorganize after your daily backup.

Before “Reorganizing” your database, make certain you have a good, current backup of your database.  The next requirement is that all Users must be out of the database to be reorganized or it will not reorganize.

Reorganizing 1^st Method:  Using the Sys000 program:  Reorganizing is an automated process.  Sys000.exe can be found in your Active Accounting folder. You only have to start the reorganization program, then using Windows Explorer ‘browse to’ and ‘select’ the database to be reorganized. 

The Reorganize tool is a program named SYS000.exe  (S-Y-S-zero-zero-zero). It is found within your Active Accounting folder on the server.  Browse to it and double click on the file name with your mouse button to cause the program to start.  The reorganizing program will ask you if you want to save the .bak file it will create in the process of reorganizing your database.  Answer ‘yes’ to the question so as to allow the system to save the .bak file.  When done reorganizing, a short message will appear indicating it is complete.

Note:  Some of you that know Windows will create an icon out of the SYS000.exe file to place on your desktop for the sake of convenience.  From then on, you will only have to double-click on the icon in order to start ‘reorganizing’ rather than having to first browse to find the SYS000.exe file on your hard disk and then double click it.  This will have the effect of making reorganization more convenient and therefore more likely to be performed on a regular basis.

Reorganizing 2nd Method:  Using the MS Access program:  What will surprise you next, is that this same Reorganization process can also be run from within the MS Access program.  If you are totally unfamiliar with MS Access we might recommend skipping this method and sticking to the SYS000 method as explained above.  In using this method the user would first start MS Access, then click on “File” then “Open” and then ‘select’ their database so that it will open within MS Access.  Then from the MS Access menu options running along the top, select “Tools” then “Database Utilities” from the drop down menu, then left click once on the option named, “Compact & Repair”.  Reorganization will proceed exactly as above in the 1st paragraph.