Business InsightsMS Office 2013 64 bit users are now able to export data to Microsoft Access Database (.accdb) from Business Insights Explorer.
There are two required components:
1. An updated Sage 100 ERP exapp.exe program that is automatically installed with Sage 100 ERP 2015.
2. The x86 (32 bit) version of the Access Database Engine.
a. This can be downloaded and installed using the following link
i. Click download
ii. Select AccessDatabaseEngine.exe (x86 version of drivers)
iii. Click Next
iv. When asked to Save or Run, select Run and follow the installation instructions.
b. If the x64 version of the database engine is installed you will not be able to install the x86 version of the database engine required for Sage 100 Business Insights Explorer. To resolve, uninstall the x64 version via Control Panel\Programs and Features then install the x86 version of the database engine.