Because of Bitness Locking .
AccessDatabaseEngine.exe Architecture: 32-bit (x86) Version: 12.0.6423.1000 Because of Bitness Locking
If you are running only 64-bit applications and Office 365 64-bit, you should download the Microsoft Access Runtime 2016 (64-bit) instead. But for the classic 32-bit compatibility, the 2010 version remains king. Raj knew better than to trust the error text literally
Raj knew better than to trust the error text literally. The file was there; the connection was the issue. He navigated to the Data tab in Excel, clicked Connections, and watched the connection string fail. It was trying to use a newer provider that didn't play nice with the legacy SQL driver the company used. It was trying to use a newer provider
Here’s a of the Microsoft Access Database Engine 2010 Redistributable (32-bit) , based on real-world usage, compatibility considerations, and common pitfalls.
The spinning wheel appeared. For a moment, the silence in the office was absolute.