CLPack: Running the Lacerte Client Database Repair Utility

1. Close Lacerte.
2. Download the Lacerte Tool Hub Install file. Save the file somewhere you can easily find it (like your Downloads folder or your Windows desktop).
3. Open the file you downloaded (lacertetoolhub_setup.exe).
4. Follow the on-screen steps to install and agree to the terms and conditions.
5. When the install finishes, double-click the icon on your Windows desktop to open the tool hub.
   

1. Open Lacerte.
2. Hold down F10 on your keyboard to bring up the Technical Support Information window.
   • On some keyboards, you may need to press the F-Lock button first.
3. Under the System Information tab, take note of the Data path, Option path, and Program path.
4. Close the Lacerte program for the affected year on all computers until the process is complete.
5. Browse to the Data path noted earlier, open the URN folder, and delete any files inside it.
6. Browse to the Option path, open the URN folder, and delete any files inside it.
7. Browse to the local Program path, open the URN folder, and delete any files inside it.
8. Go back to the Program path and locate the YYCLPACK.EXE file.
   • YY represents the two-digit tax year in 20YY format.
9. Double-click YYCLPACK.EXE to launch the Lacerte Client Database Repair Utility.

10. In the Tax Program field, select the program module in question.
    • It'll default to the last tax type that was open.
    • If you're unable to access the Calendar, choose the Reindex Calendar only option below. This feature is only available in tax year 2014 and later.

11. Make sure the Data path field is correct.
    • The utility will read the Lacerte options for the Data path and automatically set it.
    • If you need to run CLPack on a database that resides in a different location, then manually type in the path.
12. Select Reindex/Repair and click Start.
13. After reading the warning message, click Yes to continue.

14. When the CLPACK process is complete, click the Exit button to close the utility.
15. An Information window will appear informing you where the log files will be stored in case they're needed for troubleshooting. Click OK to continue.
16. Open Lacerte and make sure the client database has been corrected.

Each tax year of the Lacerte program has its own CLPack utility. The CLPack utilities are located in the Lacerte program folder. If the problem you're encountering is preventing you from opening Lacerte, use the Windows search box to find CLPACK.exe.

Follow these steps to locate CLPACK.exe:

1. In the Windows search box in the taskbar, enter YYCLPACK.exe.
   • YY represents the two-digit tax year in 20YY format.
   •  For example, to locate CLPack for 2019 Lacerte, you'd type 19CLPACK.exe in the search box.
2. If no results are found, search all other local and network drives.
3. When found, double-click the file to run.

The CLPack utility also makes a backup of the database files. The backup files are created in the data directory that CLPack repaired. For example, if you run CLPack on your individual database, and data path is C:\Lacerte\YYTax\IDATA, the backup files are created in the IDATA folder.

When you run CLPack for the first time, the utility will create a DATA?I07.001 file for each file in your database. The next time CLPack is initiated, a new set of files will be created with an extension of *.002 and so on. These files can be restored by copying them to a new folder and changing the file extension from .001 to *.DBF. Then, run CLPack on this folder to create corresponding *.IDX files for a complete database. Once the database is complete, copy over the Detail files to the new folder.