Where Troika is already installed and set to utilise an existing Microsoft Office 32-bit installation, any MSOffice reinstallation Troika is expecting would also be 32-bit.


Where a 64-bit version is installed instead, users will receive warnings on trying to enter the Troika modules and will be unable to proceed. For example:

A problem occurred in RefreshlinkedTable - ODBC--connection to 'TROIKA'

failed.

ODBC--connection to 'TROIKA' failed.

Ini File - C:\TWW\Troika\troikasql.ini


or


ODBC--connection to 'TROIKA' failed.@Object/Procedure : modTableQueryFunctions, RefreshLinkedTable
Error Number : 3151, DAO.TableDef@


Users should refer to the following article to determine whether:

  • they should be proceeding in utilising the MSAccess 64-bit installation and if so, how to make the required configuration adjustments, or
  • they should be uninstalling MSOffice 64-bit, and re-installing MSOffice 32-bit.


Installing Troika on Operating Systems Requiring 64-bit Microsoft Office


In the event of any further query, please contact support.