Occasionally Troika program files can be damaged. When this occurs, you can no longer access your Troika programs, and it is possible you may see warnings like this, on entering Troika:
The expression you entered has a function name that Troika Wealth Management can't find.
The database cannot be opened because the VBA project contained in it cannot be read. The database can be opened only if the VBA project is first deleted. Deleting the VBA project removes all codes from modules, forms and reports. You should back up your database before attempting to open the database and delete the VBA project.
To create a backup copy, click Cancel and then make a backup copy of your database. To open the database and delete the VBA project without creating a backup copy, click OK.
The VBA modules in this database appear to have been saved with errors. Access can recover the modules, but you should backup the database first. To cancel so you can make a backup copy of the database, click Cancel. Then make a backup copy of the database.
If you have a backup copy of the database, click OK. When the database opens, examine the modules to see that they are correct. If they are not, you should revert to a recent backup.
This damage can be caused by a variety of things, including your system crashing when Troika was still in use, or forced closing of the program, without waiting for the full compact process to be complete.
Damaged program files (sometimes referred to as corrupt) are often simply resolved by using our Update option from the Troika Desktop. Select the module requiring refreshing from the left hand side (un-ticking all other options), and click the ‘Update’ button.
In versions of Troika prior to release 2.08.024, the button is labelled 'Copy Down', but functions in exactly the same way.
If you still can’t access your programs after this, please contact support for further assistance.
This article was last reviewed 06/2025.