If you try this, please report back on whether it helped.
Install the 2016 64-bit if you need a 2016 driver, and then installation - Visual Studio 2019 Setup project - include Access Database Engine Redistributable 2016/2010 - Stack Overflow.Microsoft Access Database Engine 2016 Redistributable Though, in SSMS, I can see 2 providers. When prompted, choose one of the following files based on your Windows OS and TNTmips installation architecture:ccessDatabaseEngine4. Uninstall the 2016 32-bit if you have it, Microsoft access database engine 2019 redistributable 64 bit.So, although I don't know for sure that this will help, I think it's definitely worthwhile to try these steps: Which Microsoft Access database engine version is compatible of SQL server 2019 We are using the 2019 SQL version and we have encountered the SQL job termination issue due to Microsoft Access database engine version 2016 and its working on SSIS Skip to main content. I need to include the Microsoft Access Database Engine 2016 Redistributable in my application install program. Anyone tried this and successful or any workaround for running ssis in window server 2016 My platform information:- The operation system is Windows. And tried to use the excel component to preview it in SSIS, but it didnt work. I also know from testing that if the Microsoft Access Database Engine Redistributable 2016 64-bit is installed already, it is possible (at least on the machines I've tested) to install the Microsoft Access Database Engine Redistributable 2010 32-bit, and have both engine drivers installed. Anyway, we tried to install 'Microsoft Access Database Engine 2016 Redistributable' in 'Window Server 2016'. I know from testing that one cannot install the 2016 redistributable if the 2010 is installed, and It's possible that Microsoft goes ahead and removes the Microsoft Access Database Engine Redistributable 2010 32-bit rendering Alteryx incapable of reading or writing Excel and Access files/databases. It's possible that when Office 365 installs, it needs the Microsoft Access Database Engine Redistributable 2016.