+1Hi All,
I have installed Microsoft access database engine 2016 (64 bit) and I have Excel 2019 version. Still facing connection issue like. ‘Could not Connect to Database. Error number: 80004005 Failure creating file.’ If I uncheck the ‘Use ODBC 64-bit driver for connection’ then error is changing to this - ‘Could not Connect to Database. Provider cannot be found. It may not be properly installed.’
Thanks,
Tamal
+8Have you verified that it’s been installed correctly? If you type `ODBC` into the start menu and open up the ODBC Data Sources (check both 32-bit and 64-bit) you should see:
Also worth referring back to the awesome QuickTip.
+1Hi
Thanks for your quick response.
I have checked those drivers in my system, 32 bit one is not present but 64 bit one is there. Should I need both?
Please suggest.
Thanks,
Tamal
+8That’s great you just need one installed but make sure you untick the 64-bit driver checkbox in the image you shared.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.