Our labor analytics export to Excel suddenly stopped working after last week’s Windows security update. When attempting to export labor reports through Apriso Reporting, we get an OLE DB provider error. This is blocking our payroll team from generating weekly reports.
Error message:
Microsoft.ACE.OLEDB.12.0 provider is not registered
Export failed: Cannot create Excel file
Source: LaborAnalyticsExport.dll
The export worked fine until the Windows update was applied to our reporting server. I’ve verified that Excel is installed and can open files manually. Is this a known compatibility issue with recent Windows updates? Our payroll processing is delayed because of this.
Windows updates sometimes unregister the Access Database Engine components that OLE DB uses for Excel exports. Check if the Microsoft Access Database Engine 2016 Redistributable is still properly installed on your reporting server. You might need to reinstall it after the Windows update.
To check the architecture, open Registry Editor and look under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\Configuration. The Platform value will show x86 or x64. For Apriso Reporting, you typically need the 64-bit version. Before reinstalling, uninstall the current Access Database Engine through Control Panel, then download and install AccessDatabaseEngine_X64.exe from Microsoft. Make sure to restart the Apriso Reporting service after installation.
I dealt with this exact issue last month. The problem is that Windows updates can conflict with the OLE DB provider registration, especially if you have both 32-bit and 64-bit versions installed. You need to ensure the correct architecture matches your Apriso Reporting installation. If Apriso is 64-bit, you must have the 64-bit Access Database Engine installed, not the 32-bit version.